need help with image display from database

[antonyjohn]

hai friends

 

 

  i have one problem in my programming.there is a table containing some details of the product with its image..

 

in view section in my php page ,i need to show this image and the rest of the fields in the table in a row...

plzzz help me out on how to do it

[peterbarone]

I do something like this and it works well for me.

Hope it help

 

<img src=\"/imagesfolder/$row[imagename]\" >

[antonyjohn]

hai friends

 

 

  i have one problem in my programming.there is a table containing some details of the product with its image..

 

in view section in my php page ,i need to show this image and the rest of the fields in the table in a TABLE  Row...

plzzz help me out on how to do it

 

 

Note: it shuld be displayed in a table

[GingerRobot]

It'll look something along the lines of:

 

<table>
<tr><td>Var1</td><td>Var2</td><td>Image</td></tr>
<?php
$sql = "SELECT * FROM `yourtable`";
$result = mysql_query($sql) or die(mysql_error());
while($row = mysql_fetch_assoc($result)){
echo '<tr><td>'.$row['var1'].'</td><td>'.$row['var2'].'</td><td><img src="images/'.$row['images'].'" /></td></tr>';
}
?>
</table>