Re: Links script

Thanks to both of you for that. Those were exactly what I was after. > 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 > > -- > 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 >