|
$sql_user="select * from user_info where user_username='".$array_article["user"]."'";
$query_user=mysql_query($sql_user, $connect);
$array_user=mysql_fetch_array($query_user);
echo " Author: ".$array_user["user_username"]." ";
echo "Level: ".$array_user["user_level"]." ";
echo "From: ".$array_user["user_city"]." ";
$sql_num="select * from bbs_article where user='".$array_user["user_username"]."'";
$query_num=mysql_query($sql_num, $connect);
$result=mysql_num_rows($query_num);
echo "No. of articles: ".$result." ";
echo "Registration date: ".date(Y, $array_user["user_time"])."-".date(m, $array_user["user_time"])."-".date(d, $array_user["user_time"]);
?>
|