Image Issues n php

[depojones]

Hello,

 

I created a script that can upload an image to a folder and store the image file name to Mysql DB. I just wanna know, how do i retrieve all the images on the same page.

[ialsoagree]

You would run a select statement on your database with no where or limit clauses.

 

Beyond that, I don't think we can help you without seeing relevant code.

[onthespot]

If the names are all stored within the same table, you can just SELECT the names and then run the neccessary script to allow those image names to do something!

[depojones]

I was able to find solution myself. For anyone who's viewing this, I managed to use the following.

<?php
   include 'db.php';
$sql_ret = mysql_query("select pic_name from $tbl_name");
while ($row = mysql_fetch_array($sql_ret)) {
        echo '<img src=upload'. $row['pic_name'].'><br><br>';
}    
?>

 

Thanks

 

[Ken2k7]

You should add an alt attribute to img.