I click on a image on textimage20.php
It takes me to text4.php but it all displays is:
SELECT gameandtoyname, pricevalue, bigdescription, dollsimage.image_id, dollsimage.image_date, doll.pricetype, prices.pricetype, prices.pricevalue FROM dollsimage, doll, prices WHERE doll.pricetype = prices.pricetype and dollsimage.image_id = '123' and doll.gameandtoyname = '123' and doll.bigdescription = '123'
Then I see the border, an X in there for the image
And then $0.00
Thank you for any help.
This is my code:
Textimage20.php
[HTML]
[PHP]
echo '<TD> <a href="http://localhost/text4.php?image_id=123"> <img border="1" height="90" width="100"
src="imagedolls.php?act=view&iid=' . $row['image_id'] . '"> </a> ' '</TD>' ;
[/PHP]
[/HTML]
text4.php :
[HTML]
[PHP]
$id = $_GET['image_id'];
$sql = ("SELECT gameandtoyname, pricevalue, bigdescription, dollsimage.image_id, dollsimage.image_date, doll.pricetype, prices.pricetype, prices.pricevalue
FROM dollsimage, doll, prices
WHERE doll.pricetype = prices.pricetype and dollsimage.image_id = '$id' and doll.gameandtoyname = '$id' and doll.bigdescription = '$id'
");
echo "$sql <br>";
$row = mysql_fetch_array($result);
echo '<TD> <img border="1" height="90" width="100"
src="imagedolls.php?act=view&iid=' . $row['image_id'] . '"> ';
echo '<BR>' .$row['gameandtoyname'] ;
echo '<BR>' .$row['bigdescription'] ;
$row['pricevalue'] = number_format($row['pricevalue'],2, '.', '');
echo '<br>';
echo '$' .$row['pricevalue'].
[/PHP]
[/HTML]