Gerry,
the following is your problem:
you fetch a row from the query result in each iteration:
> while ($row = mysql_fetch_array($sql_result)) {
and the use the value of $ID.
> $fn = "/images/$ID.jpg";
you need to fetch the value of the ID column into the ID variable
before. Assuming your select looks like the following:
select ID, description, blah from images;
you need to do something like
$ID = $row[0];
$description = $row[1];
$blah = $row[2];
Or you just change your while condition to
while( list( $ID, $description, $blah ) = mysql_fetch_row( $result ) ) {
Cheers,
Ben
Gerry wrote:
>
> Hello again:
>
> Ben Peter wrote:
> >
> > Gerry,
> >
> > could you give us a bit more code, esp. the while or for loop that
> > surrounds the code you have quoted?
> >
> > Cheers,
> > Ben
>
> Sorry for the confusion, and yes I did mispelled camera in english. Here
> is more of my sloppy code. I might have an extra }...not sure though
> since I have anther couple of "ifs" above it. the code works fine, but
> not the "(!$file_exists)" part since it seams it is not checking and it
> gives the same result all over the table--"no image". I did change
> things as suggested I think, but stll get the same thing.
>
> echo"<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\"
> width=\"100%\" bgcolor=\"ffffff\"\n>";
> echo"<tr>/n";
>
> while ($row = mysql_fetch_array($sql_result)) {
>
> echo"</td><td width=\"20%\" align=\"center\" valign=\"top\"><font size=\"2\">/n";
> echo $row["name"];
> echo "</font>\n";
> echo"</td><td width=\"20%\" align=\"center\" valign=\"top\"><font size=\"2\">/n";
> echo $row["Color"];
> echo "</font>\n";
> echo"</td><td width=\"20%\" align=\"center\" valign=\"top\"><font size=\"2\">";
> echo $row["Size"];
> echo "</font>\n";
> echo"</td><td width=\"20%\" align=\"center\" valign=\"top\"> </form> ";
> echo"<td width=\"20%\" align=\"center\" valign=\"top\"><font size=\"2\">";
> if (!file_exists($fn)) {
> echo "not working yet";
> } else {
> echo'<img src=\"http://site.com/images/camera.gif\">';
> clearstatcache();
> }
> echo"<tr><td colspan=\"5\" valign=\"top\"><hr size=\"1\"></td></tr>";
> }
> echo"</table>";
> }
>
> --
> Gerry Figueroa
> -------------- - - - - - *
> War does not determine who is right, war determine who is left.
>
> |XXXXXXX|------^|XXXXXXXXXXXXXXXXXX|
>
> --
> PHP General 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 General 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]
