On 2002.01.15 23:30:25 -0600 chip wrote:
> I have a database set up with tables of images. I have pages set up to
> display the images 12 per page in a table of 2 rows/6 cols. There is a
> next
> link that loads the next 12 images from the database. All works just fine
>
> except for one little problem - the first time the page is loaded the
> first
> image is not number 1, but rather number 13. It is skipping the first 12
> images.
> 1) What do I need to do to fix this? Must be something in the code below?
> 2) When I get to the last page of images, the next button is still active
> and
> will, when clicked on, load an empty page, because there are no more
> images
> to display. How do I prevent this (make the last page definately the last
>
> page)? (new images are often being added, so hard coding a last image
> number
> won't work)
>
> <?
> $new_pic=$pic+12;
Is $pic already set by the HTTP_GET_VARS here?
> $conn=mysql_connect("localhost", "chip","carvin") or die ("Could not
> get
> the databse");
> mysql_select_db("images", $conn) or die ("Could not select the
> database");
> $sql="select * from ab limit $new_pic,12";
Assuming that $pic is 0, then $new_pic is 12, so you're selecting with
LIMIT 12, 12. You probably want to use $pic here, right?
> $result=mysql_query($sql);
> while ($row=mysql_fetch_array($result))
> {
> printf("<td align=\"center\"><a href=\"%s\"><img
> src=\"../thumbs/%s\"></a></td>\n", $row["name"], $row["name"]);
> $i++;
> if($i %6==0)
> {
> echo "</tr>\n";
> }
Note that if the select statement gives you other than 6 or 12 images
(which it probably will on the last page), that </tr> will never get
echoed.
> }
> echo "<tr>\n<td colspan=\"6\" align=\"center\">\n<a
> href=\"../index.html\">Home</a> \n<a
> href=\"index.php?pic=$new_pic\">Next</a>\n</td>\n</tr>\n";
> ?>
To find out if $new_pic pointed to a valid image you would probably need
to do a "select count(*) from ab" to get the total number of records. If
$new_pic is less than the count, then show the link.
> --
> Chip W
> www.wiegand.org
> <+><+><+><+><+><+><+><+>
> Windows 95/NT - 32 bit extensions and a graphical shell for a 16 bit
> patch
> to an 8 bit operating system originally coded for a 4 bit microprocessor,
> written by a 2 bit company that can't stand 1 bit of competition.
> <+><+><+><+><+><+><+><+>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
