Hey all..

$result =mysql_query("SELECT * FROM list WHERE buscat1='$category' OR buscat2='$category' OR buscat3='$category' ORDER BY name ASC",$db)
or die("lINE 8");

this gets everything in the database with the a particular catogry. And will display all hte results on one page... Now.. I need to make i grab them all...sort them alphabeticly by collum name.. then grab the first 20. that I can do kinda.. the problem lies in that I need to have a way to tell it to grab all the results with the approiate category, then sort them alphabeticly. Now... after the page with the intial 20, I need a link to the same page, but with the next 20 results.

aby ideas?