J_ConnectDB(); $juice->J_SelectDB(); $juice->set_char_utf8(); $sql_v = "UPDATE gallery SET views = views + 1 WHERE gallery_id = '".$_GET["id"]."'"; $juice->J_ExecuteNonQuery($sql_v); $f = "gallery.*,user_post_gallery.user_name,concat(user_post_gallery.first_name,' ',user_post_gallery.last_name) as fullname "; $tbl = " gallery,user_post_gallery where gallery.post_by = user_post_gallery.user_id and gallery.gallery_id = ".$_GET["id"]; $rs = $juice->J_Select($f,$tbl); if(count($rs)){ foreach($rs as $read){ $gallery_title = $read["gallery_title"]; $gallery_detail = $read["gallery_detail"]; $post_date = $read["post_date"]; $post_by = $read["fullname"]; $views = $read["views"]; } } ?>
  ภาพกิจกรรม
โพส โพสโดย อ่าน