
Originally Posted by
you
$query = "SELECT * FROM $tbl_name ORDER BY file_name DESC";
$result = mysql_query($query) or die('Error, query failed');
you need to add a where clause
PHP Code:
$query = "SELECT large, file_name, thumbnail FROM ".$tbl_name." WHERE _field_ = '_condition_' ORDER BY file_name DESC";
also you should add an alternate description so if the thumbnail cannot be displayed the user will have an idea of what its supposed to be, and thus would know if he/she would like to view the full image. and not everyone will think about hovering over the empty space to see the title that you have assigned. if someone goes onto a page and sees all empty parts like that well they are likely to navigate somewhere else, but if there is a textual representation they would be much more likely to click on one/more of the picture(s)
Code:
<img src='".$row['thumbnail'].'" alt="'.$row['file_name'].'">
Bookmarks