",$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 " |
";
?>