You should also add an ORDER BY clause in there, as the SQL standard doesn't
guarantee the order that rows are retrieved in. There's a chance that
you'll get, say, 20 rows on the first page, go to the second page and get
some of the rows you've already seen on the first page. If you use an ORD
---
From: Jason Soza [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 16, 2002 1:31 PM
To: [EMAIL PROTECTED]
Subject: [PHP] Making Multiple Pages
I have some ideas on how this should be done, but I'm at work and can't
really test them, so I was thinking maybe I could run it by you all and
ma
number of total rows, divide by 20, and
build a list of links in a for() loop.
$num_rows = mysql_num_rows($sql);
$num_pages = floor($num_rows/20);
for ($i=0; $i
To: "Kevin Stone" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Thursday, May 16, 2002 1:15 PM
Subject: Re: [PH
=red&i=25
Then have a $_GET['i'] variable in my script and set $i equal to that?
Your help is appreciated. Thanks again.
Jason Soza
- Original Message -
From: "Kevin Stone" <[EMAIL PROTECTED]>
Date: Thursday, May 16, 2002 10:53 am
Subject: Re: [PHP] Making Mul
ql.com for more information about using LIMIT in your queries.
-Kevin
- Original Message -
From: "Jason Soza" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, May 16, 2002 12:31 PM
Subject: [PHP] Making Multiple Pages
> I have some ideas on how this
I have some ideas on how this should be done, but I'm at work and can't
really test them, so I was thinking maybe I could run it by you all and
maybe get some feedback and/or new ideas.
I have a PHP/MySQL-generated page that displays image thumbnails.
Currently, I have a loop that makes a tabl
6 matches
Mail list logo
