Image Display Issue

[nwclark]

I am a noobie.. so bare with me. This has got to be easy..but i can;t figure it out.

I am trying to display and image based on a photo name in a mysql database.

That would be easy enough except I need to get that name from a recordset because this is a detail page from a master set and it dynamic.

This is the code i was trying that doesn't work..

<img src="http://bytes.com/topic/php/idphoto/<?php echo $row_DetailRS1.photo ?>" width="157" height="232" align="top" />

The whole photo names are stored in the database (example photo.jpg)

[prabirchoudhury]

hey .. a quick question .. what name you store the image in database? is that with extension (.jpg , .gif) ? are all the images saved in same directory or different in server ?

[nwclark]

@prabirchoudhury
I rename the images upon upload to their unique username. As far a extension.. eithrer jpg, png or gif.. They are all in the same folder on the server.

[prabirchoudhury]

ok..

here your image tag should be

<img src="image_directory/<?php echo $row['imagename']; ?>" width="157" height="232" align="top" />
 

that should work if you supply all right information abt immage

:)

[nwclark]

@prabirchoudhury
But i need to pull the image name from the data base?

[prabirchoudhury]

ok...


1. you need to connect with database using php

 <?php
 $mysqlconnec= mysql_pconnect($your_hostname, $db_username, $db_password) or die((mysql_error());
    $db = mysql_select_db($your_database, $mysqlconnec);
 
 ?>
 
 

2. make a select statement of your table where you could get the images name

<?php
 
$sql = "SELECT * from your table_name ";
//execute the query
 $csr = mysql_query($sql);
// retrieve the image details frm table
while ($row=mysql_fetch_array($csr)) {
 
 
$your_image_name = $row['imagename'];
 
}
 
?>
 
 

3. now you got your image details so could add this in html

 
 
:)
 
 
   1. <img src="image_directory/<?php echo $your_image_name; ?>" width="157" height="232" align="top" />
   2.  
 
 
 

you need to read the basic php /mysql tutorials

[Markus]

It depends what database you're using. Google '<database type> php tutorial'.

[nwclark]

Thanks so much!!! it worked..