"; $sql_blog = "select * from blog order by postdate DESC limit 20"; $result_blog = mysql_query($sql_blog) or die ("Can not excute SQL_blog"); while($data_blog = mysql_fetch_array($result_blog)){ $sql_custo = "select real_name as custo_fname,email_address as custo_email,avatar as image_path from smf_members where id_member = '$data_blog[postby]' "; $result_custo = mysql_query($sql_custo) or die ("Can not excute SQL_custo"); $data_custo = mysql_fetch_array($result_custo); $sql_cate = "select cate_id,catename_en from blog_category where cate_id = '$data_blog[cate_id]'"; $result_cate = mysql_query($sql_cate) or die ("Can not excute SQL_cate"); $data_cate = mysql_fetch_array($result_cate); $sql_countcomment= "select count(*) as countcomment from blog_comment where blog_id = '$data_blog[bid]'"; $result_countcomment = mysql_query($sql_countcomment) or die ("Can not excute SQL_countcomment"); $data_countcomment = mysql_fetch_array($result_countcomment); $sql_view= "select count(*) as countview from blog_view where id_blog = '$data_blog[bid]'"; $result_view = mysql_query($sql_view) or die ("Can not excute SQL_view"); $data_view = mysql_fetch_array($result_view); echo ""; echo ""; } ?> ";// ?>    

More...