Okay...I read the article here on the site (Building Next/Prev Buttons for Query Results (Part 2) by Rod) and it worked wonderful....sort of. I have about 10 different genre's of games and each genre has it's on page. All of the games are stored in one table in one database. One of the fields is "category" which has the genre the game is in (sports, action, etc.)...and one each page (shooting-games.php for example) the query calls all the games with "shooting" in the "category"....well the problem with the "next/prev" script is that it counts all the rows in the whole table and then divides that number by my limit i've set for each page. Is there a way to only count the number of rows with the specified genre in it (ie only count the rows with "shooting" or "racing")?
just use a GET var and a WHERE statment in your query:
<?php $query = "select * from table where category ='".$_GET['cat']."' "; $query .= "LIMIT blah,blah";//your limit stuff here. ?>
