images from database

rangus

Hi,

I have managed to put an image into a database as reference at present a reference may look like F😛HPuploadtempphp60.tmp i need to retrieve it from the database so that the correct id number corresponds to the correct picture for example the one above. How do i get it from database into a php form.

Please help i am new to this.

Thanks

sid

$query = "SELECT image
FROM dbtable
WHERE id = '" . $id . "';";

if ($imageFile = mysql_fethc_array()) {
    print "<IMG SRC=\"" . $imageFile[0] . "\">
}

rangus

Hi,

This is my code i dont if this helps:

<html>
<head>
<title>Untitled Document</title>
</head>
<style type="text/css">

#d5 {position:absolute; left:50; top:190; width: 100; }
#d6 {position:absolute; left:50px; top:270; width:400px; background-color:#99CC99; border:outset 2px #000000; font:arial; font-size:14pt; font-weight:900px }
#d7 {position:absolute; left:500px; top:270; width:400px; background-color:#99CC99; border:outset 2px #000000; font:arial; font-size:14pt; font-weight:900px }
#d8 {position:absolute;left:50px; top:293px;width:400px; background-color:#FFFFCC; border:outset 2px #000000;font:arial; font-size:12pt;font-weight:700px;height: 238px;}

</style>
<body>
<?php
$id=$_GET['id'];

$user="rishi";
$database="registration";
$password="speed";

mysql_connect("localhost",$user,$password);
@mysql_select_db($database) or die( "Unable to select database");

$sql="select * from auctions where id="$id";

$result=@($sql);
while($row+mysql_fetch_array($result))
{
?>

<div id="d4">   <?echo $row["title"];?></div>
<div id="d5"><img src="Graphics/buttons/backtolistingsbutton.png" width="190" height="40"></div>
<div id="d6"><center>Bidding Information</center></div>
<div id="d7"><center>Postage Information</center></div>
<div id="d8">
<center><br>
   Current Price:  <b><?echo $row["startprice"];?></b><br>