[RESOLVED] Help with echo results

mjgdunne

Hi, i am storing images in a file directory, i am storing information in the database and the image name, i have a query which prints out the results, my question is how to echo out the image.
I have this code:

echo "<tr><th>Image</th>";
		echo "<td>";
    	echo "<img src='upload/<?=$file_realname?>'>";
echo "</td>";

I name of the field which stores the image name in the database is called image.
Any help would be great thanks.

sheephat

have you included the extension in the database?

Echo out this way just incase your php software doesnt recognise short tages:

<?php echo $file_realname; ?>

check the source via internet explorer or the properties of the image to see what the output is.

mjgdunne

In my database, i have a field called images which simply holds the image name eg image.jpg
The source where the files are located are: http://localhost/upload/
I just stuck in $file_realname as an example.
Any help would be great.

illzz

Looking at your syntax and assuming that the surrounding code is PHP, it looks like you are trying to embed PHP within PHP code.

Try this:

<?php
echo "<tr><th>Image</th>"; 
        echo "<td>"; 
        echo "<img src='upload/" . $file_realname . "'>"; 
echo "</td>"; 
?>

This code assumes that $file_realname is defined as the image's file name.

illzz

Are you having problems getting the name from the database? Or just putting into the page once you have it?

sheephat

so something like this is what you need:


<?php 


$results = mysql_query(SELECT * FROM table);

while($row = mysql_fetch_array($results)){
echo "<img src='upload/".$row['fieldwithnames']."'/>";


 }

?>

Ok i done that in my head in this editior so it could be wrong.

mjgdunne

How would i get the image filename, as the image filename is in the database?

sheephat

change $row['fieldwithnames'];

'fieldwithnames' -> to your field name

mjgdunne

Hi thanks, that worked perfectly, thanks very much, any chance you would know how to resize the image that is outputted?

sheephat

you can just add the width and height tags to the IMG tag, or make the php code generate a thumbnail

mjgdunne

Ok great thanks for your help

sheephat

No problem,

Make sure you mark this thread as resolved.