Let's tackle the first one first -
On Tuesday 15 January 2002 10:20 pm, Steven Cayford banged out on the keys:
> On 2002.01.15 23:30:25 -0600 chip wrote:
> > won't work)
> >
> > <?
> > $new_pic=$pic+12;
>
> Is $pic already set by the HTTP_GET_VARS here?
I don't know. How do I set this? I was reading the online manual about
http_get_vars and it didn't help, and doesn't have any examples.
--
Chip
> > $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]
--
<+><+><+><+><+><+><+><+>
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]
