php mysql查询分页查询语句_PHP – 使用分页的MySQL查询

我将如何制作这个 MySQL&的分页脚本？ PHP查询.

if (isset($_GET['c'])) {

$c = $_GET['c'];

}

$query = mysql_query("SELECT * FROM Categories WHERE category = '$c' ");

WHILE($datarows = mysql_fetch_array($query)):

$id = $datarows['id'];

$category = $datarows['category'];

$code = $datarows['code'];

endwhile;

$query2 = mysql_query("SELECT * FROM Games WHERE category = '$code' ");

WHILE($datarows_cat = mysql_fetch_array($query2)):

$title = $datarows_cat['title'];

$description = $datarows_cat['description'];

$imgurl = $datarows_cat['image_name'];

$category = $datarows_cat['category'];

$views = $datarows_cat['view_count'];

$pagename = $datarows_cat['pagename'];

$featured = $datarows_cat['featured'];

if ($featured =="1") {$f = " Featured"; } else {$f = "";}

if(is_int($views/2)) {

$views = $views / 2;

} else { $views = $views / 2 + .5; }

if (strlen($description) > 95) {

$desc= substr($description,0,95);

$desmod = "$desc...- Read More";

}

else {$desmod = "$description";}

echo "$f - $title - $desmod
";

endwhile;

例如,当我访问http://my-site.com/categories/Action时,代码在我的类别表中查找该类别,然后一旦获得该类别的唯一代码,它就运行另一个查询以查找具有该类别代码的另一个表中的所有游戏.然而,目前,我为一个类别加载了200个游戏,这导致了大量的加载时间.

谢谢你的帮助！