How to pull images from MySql database using PHP

[NabilChicago]

Hi,
I have a table in my database which is called raja_products, this table contains (productID, productPrice, productImage, productDescription).

productImage contains picture`s names of the products (eg, shoes.jpg). I already uploaded these pictures to a folder called images. What I`m looking for is a script that can display these images in my site.

Thank you[/url][/list]

[bezmond]

Code: Select all

<?
mysql_connect("host","username","password) or die("Couldn't connect to mysql, whoops!");
mysql_select_db("databasename") or die("Couldn't open the database, did ya screw up?");
$query = "SELECT * FROM raja_products";
$result = mysql_query($query);
while ($row = mysql_fetch_array($result))
{
$imagefile = $row["productImage"];

***you can insert variables for the other fields here too***
?>
<img border="0" src="imagesfolder/<? echo $imagefile ?>" width="640" height="480">
<? } ?>

Hope that works,
Andrew

[NabilChicago]

:lol:
Thank you very much, it works.

[bezmond]

Cool. Your welcome

Andrew