RE: [PHP] Links script

As far as the next and back buttons go, checkout phpbuilder.com. In the columns section there should be a couple of tutorials on exactly that. I used the code for a project I was working on and it worked brilliantly. On Mon, 08 Jan 2001, Cal Evans wrote: > What database? If you are using MySQL, use the LIMIT option in the select. > > http://www.mysql.com/documentation/mysql/commented/manual.php?section=SELECT > > Cal > http://www.calevans.com > > > -----Original Message----- > From: James, Yz [mailto:liljim@btconnect.com] > Sent: Sunday, January 07, 2001 3:01 PM > To: php-general@lists.php.net > Subject: [PHP] Links script > > > Hey there, > > I am currently writing a links script which I'd like to list links stored in > a MySQL database. Links can be submitted by the client, etc etc. > > That's not where my problem lies. At the moment we limit the client to 20 > links per page. So, when thre links database reaches over 20 links, I'd > like the first page to display the last 20 links (added by date), and then > automatically insert a "Next page" link, which will take you to another page > with the next 20 links. If the links amount to 40 or more, I'll need a > "Back button" to take them back through the pages. I am garbling. Bah. > > Basically, what I guess I am asking is, how do I get the links pages to read > rows from the database in chunks of 20? I know it'll be using LIMIT, but I > don't want to have to write into the links script a load of if statements > (I'm not too hot on For and While statments yet) which read > > <? > > if ($num_rows > 20) { > echo "<a href=\"links.php?limit21,40\">Next 20 links</a>" > } > > ?> > > etc etc. > > Sorry for the useless explanation, but hopefully one of you will gather > roughly what I am saying. > > Thanks, > James. > > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net > For additional commands, e-mail: php-general-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net > > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net > For additional commands, e-mail: php-general-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net