"; echo "
",$user['user_login'],""; /* showing mail */ $q="SELECT mail.mail_text,mail.mail_from,user.user_login as user_name FROM mail left join user on mail.mail_from=user.user_id where mail_new='yes' and mail_to='$user_id'"; $q.=" ORDER BY mail_id DESC"; echo ""; $result=mysql_query($q); while ($mail=mysql_fetch_array($result)) { $year=substr($mail['mail_timestamp'],0,4); $month=substr($mail['mail_timestamp'],4,2); $day=substr($mail['mail_timestamp'],6,2); $hour=substr($mail['mail_timestamp'],8,2); $min=substr($mail['mail_timestamp'],10,2); $sec=substr($mail['mail_timestamp'],12,2); echo ""; echo "",$mail['user_name'],":"; echo $mail['mail_text'],"
";; } echo ""; ?>