How to display images from MySQL database?

[JsteRmX]

On my site, I allow users to either select an image or to type in the path of their image which is hosted elsewhere. The file name or file path gets stored in my database. Now I want to display their image on a page. How do I do this? This is the code I have for it...

$sql = "SELECT * FROM user";
$query = mysql_query($sql);
while($row = mysql_fetch_array($query)) {
echo "<tr>";
echo "<td>".$row['user_image']."</td>"; 
echo "</tr>";

When I try this, it only displays the file name or path of the image, not the actual image. How do I fix this?

 

[Noobie]

$sql = "SELECT * FROM user"; 
$query = mysql_query($sql); 
while($row = mysql_fetch_array($query)) { 
echo "<tr>"; 
echo "<td><img src =\"" . $row['user_image']."\"></td>";  
echo "</tr>";

 

[JsteRmX]

thank you noobie, that worked perfect! Now i just have to try and get it formatted correctly. I want this image to appear to the right of a URL that is also displayed from the DB. a simple table with two columns would work.
do you know how to do this? here is the complete code:

$sql = "SELECT * FROM user_extended";
$query = mysql_query($sql);
while($row = mysql_fetch_array($query)) {
echo "<tr>";
echo '<td><p class="style1"><a href="'.$row['user_homepage'].'"><size=10>'.$row['user_homepage'].'</size></a></p></td>';  
echo "</tr>";
}
$sql = "SELECT * FROM user";
$query = mysql_query($sql);
while($row = mysql_fetch_array($query)) {
echo "<tr>";
echo "<td><img src =\"" . $row['user_image']."\"></td>";
echo "</tr>";

 

[klavixs]

hello

bump ... sorry i misunderstood ... bump

 

[einjhel]

wouldn't that last code make it still go on a one column table with all the urls on top then all the images at the bottom part?

ok this is just a draft....

$sql = "SELECT * FROM user_extended";
$img_sql = "SELECT * FROM user";
$query = mysql_query($sql);
$img_query = mysql_query($img_sql);
while($row = mysql_fetch_array($query) && $row2 = mysql_fetch_array($img_query)) {
echo "<tr>";
echo '<td><p class="style1"><a href="'.$row['user_homepage'].'"><size=10>'.$row['user_homepage'].'</size></a></p></td>';  
echo "<td><img src =\"" . $row2['user_image']."\"></td>";
echo "</tr>";
}

i think there's better way to code this though.

 

[JsteRmX]

thanks for trying einjhel, but that didnt work either.

Now, the user_homepage does not show up, and the images just show as red X.

this is driving me crazy, lol i cant believe we still havent figured it out.