[Resolved] Viewing Images in mysql & PHP

[artisticre]

MY Code Here:
<?php
$db = mysql_connect("xxx", "xxx", "xxx");
mysql_select_db("xxx",$db);

$result = mysql_query("SELECT image from TShirts where image = 'Bees'",$db);
$result1 = mysql_query("SELECT image from Earrings where image = 'Apples'",$db);

$path ="http://xxx/Images/TShirts/";
$path1 ="http://xxx/Images/Earrings/";
$gif =".gif";

echo ("
<img border=0 width=167 height=223 src=\"$path".$result[image]."$gif"."\">
<img border=0 width=167 height=223 src=\"$path1".$result1[image]."$gif"."\">
");

?>

Its not pulling the image name out of the database

HELP

[dalecosp]

Originally posted by artisticre
MY Code Here:

<?php
$db = mysql_connect("localhost", "rcalthns", "snickers");
mysql_select_db("cindystshirts_com",$db);

$result = mysql_query("SELECT image from TShirts where image = 'Bees'",$db);
$result1 = mysql_query("SELECT image from Earrings where image = 'Apples'",$db);

$path ="http://www.cindystshirts.com/Images/TShirts/";
$path1 ="http://www.cindystshirts.com/Images/Earrings/";
$gif =".gif";

echo ("
<img border=0 width=167 height=223 src=\"$path".$result[image]."$gif"."\">
<img border=0 width=167 height=223 src=\"$path1".$result1[image]."$gif"."\">
");

?>

Its not pulling the image name out of the database

HELP [/B]

Have you tried echoing out the variable? I imagine you'll find that it's "Resource ID 1" or some such....

Try this before your 'path' statements:

$result=mysql_fetch_array($result);
$result1=mysql_fetch_array($result1);

...it might do what you want....

EDIT: dunno what's up with that semicolon...I've tried twice to fix it; you know, of course it goes on the line above.... 🙂