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.
Did you know?Explore Trending and Topic pages for more stories like this.
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?
No comments posted yet
Your Answer:
Login to answer
104 
35 
Other forums
DATEDIFF Question
First time post, and of course it is a help question.
I am using a WP plug-in to display prev
Automatic Webpage ??
I have a page www.mysite.com/test.php with a
<form>
<textarea name=&q
PHP switch function help
Hi, I am trying to create a search function for a directory website. On the search function on html
Good Programming and Web Design Books
Hi,
I recived a pm today from a fellow phpfreaker regarding php books, i replied with the fo
xml
<?php
echo "<h1>XML Articles</h1>";
$home
Reading waves
Hi,
I am trying to find a way of finding the highs and lows on a graph line, the line points
couldn't connect to your database
Hello I am new to php mysql
Actually i have read A tutorial on nettuts
"http://net.tu
Namespace Problem
I'm having problem with a section of code with a variable namespace.
This code works fine:php slowing my site?
Hi all,
I think that one of the reasons that my site doesn't work fast is that the code is ve
$variable = $variable
Hello
Sorry if this is a really simple question but I have run out of ideas. Is there a reall
