[PHP] previous and next link

I have this code and I wanna display only 10 records on page. For the rest of them I wanna use a next link(or a previous link). Please tell me hoe can I do that. $sql = SELECT * FROM categorie ; $rezultat = mysql_query($sql); $num_rows = mysql_num_rows($rezultat); while

Re: [PHP] previous and next link

--- phpu [EMAIL PROTECTED] wrote: I have this code and I wanna display only 10 records on page. Use the LIMIT clause in your select statement: http://www.mysql.com/doc/en/SELECT.html Hope that helps. Chris = Become a better Web developer with the HTTP Developer's Handbook

[PHP] previous and next link

I've tried but i don't know how to put it in my script. And also i don't know how to display it in page. Here is my script and I hope you could help me with this one. thanks $sql = SELECT * FROM categorie ; $rezultat = mysql_query($sql); $num_rows = mysql_num_rows($rezultat); while

RE: [PHP] previous and next link

[snip] I've tried but i don't know how to put it in my script. And also i don't know how to display it in page. Here is my script and I hope you could help me with this one. thanks [/snip] Google is SO cool!!! :) http://www.onlamp.com/pub/a/php/2000/11/02/next_previous.html Have a pleasant and

Re: [PHP] previous and next link

--- phpu [EMAIL PROTECTED] wrote: I've tried but i don't know how to put it in my script. Here is your SQL statement (between the quotes): $sql = SELECT * FROM categorie; Add a LIMIT clause to that statement. The syntax is described at the URL I sent you. Hope that helps. Chris =