Re: Links script

You may also download such PHP script from http://www15.brinkster.com/codetogo/links.html Good luck Sabina ----- Original Message ----- From: James, Yz <liljim@btconnect.com> To: <php-general@lists.php.net> Sent: Sunday, January 07, 2001 1:36 PM Subject: Re: [PHP] 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 > > > > > > -- > 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 > >