The next part I tackled and won! Hard to believe actually, but I got the
problem with last page fixed.
On Tuesday 15 January 2002 10:20 pm, Steven Cayford banged out on the keys:
> 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.
I did incorporate the count(*) function to show a total number of pics in
each database, at the bottom of the page with the page and home links.
Here is the code I used to fix the last page problem -
$result=mysql_query($sql) or die ("The query didn't work, oops");
if (mysql_num_rows($result) == 0)
{
echo "<tr>\n<td colspan=\"6\" align=\"center\">\n<font
size=\"+2\">Oops, you've reached the end of the line.\n<br>\n<a
href=\"../index.html\">Home</a></font>";
}
else
{
while ($row=mysql_fetch_array($result))
{
the rest of the code.....
And it works great.
That takes care of the two questions I had to begin with. Thanks for the
help, I appreciate your kindness and patience, sometimes even the best books
and manuals fall a bit short of such common, simple or mundane tasks.
--
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]
