Displaying image from database

Posted on 16th Feb 2014 07:03 pm by admin

Hi,

I've got a site where that's got a database behind it. Currently it has loads of items in rows that all have different pictures. There is a field called "Image" that has the name of the image ie. example.jpg.

Then I have a folder on my webserver called image where the pictures are stored with the same file names and extensions.

Now, I want to display the correct image for the item that the page is showing. I have this code but it's just showing the usual box with a red X in the top left.

I should also point out that the 'Item' line is working correctly and displaying the name of the item.

Quote<table border='1' align="left" width="100%">
<?php
while($row = mysql_fetch_array( $result )) {
$dir = '/image';
$image = $row['Image'];
echo('<b><h1>'.$row['Item'].'</h1></b><br />');

echo "<tr>";
echo "<td width=15%>"."<img width=100% src='$dir/$image /'></td>";
echo "<td width=85% align=center>Description</td>";
echo "</tr>";
}
?>
</table>
Any ideas why this isn't working?

Your Answer:

Login to answer

Other forums

Calling a Procedure with IN & OUT Parameters
Hello,

I usually call my procedures using the following way

declare variable e

Change Web page language
i doing this thing first time but i dont find any suitable solution for it. On the demand of user. I

While Problem
i am having a problem with a while statement here is the code
Code: [Select]<?php
sess

Credit card verification
I have a client who wants to process credit card transactions from his web site rather than the goin

Recognising Revenue daily
Hello.
Has anyone come across daily recognition of deferred income?
We want to implement R

defining website tags
Hi,

What would be the best way to define tags for my site, such as website title, url etc.

Read from a text file after a specific word
Hi all.

I have a text file that looks like the one below.
I know how to open the text fi

Target costs on Process orders not calculating
Hi All,

We have released standard costs for all the materials. We have also done Goods r

Can't shake the "Warning: include()" error
I've just uploaded my site to a new server and where I have PHP include tags in my HTML, the browser

PHP page loading in Firefox but not in IE
hello,

i am currently doing a project in PHP and i have a problem. If I view the project in M