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

strtotime issue
Hey all,

I'm playing around with some code, and basically the idea is:

Person changes

WORDPRESS - Multiple Loops Only Going to One Post?
I have various pages with multiple loops and i need them to be individual to all other categories.

Match stored value with the current value in a loop
Hello,

I have a MySQL db were I store articles in.

I have a form to fill these article

single values into sql field
i have a form which i want the user to able to select multiple answers. But i want the answers to be

Month String to Numeric?
Hi guys,

Given a month as a string, is there a simple way to find the numeric representation

cURL and Sessions
Ohai.

So, I'm trying to cURL a bunch of things off of a page, and put them into a session. I'

Preloading images
Posting this question here because I am not sure where this should belong.I am building an asp.net a

import table with dependency
Hi

What is the best way to import table back which has dependency?

SQL> cre

Parse Error
Hi Guys,

I have a function in my class which returns a string link variable. The problem is i

close site for maintenance
i get a tutorial, saying the following code can put our site offline, and only the developer can vie