I have been working on an upload script, and now it's time to display both orginal and thumbnail on the broswer.
This is my SELECT queries:
Code: Select all
$query = "SELECT * FROM tbl_Files WHERE prop_num = $propnum";
$result = mysql_query ($query) or die(mysql_erro().'<p>'.$query.'</p>');
$query2 = "SELECT * FROM tbl_thumb WHERE prop_num = $propnum";
$result2 = mysql_query ($query2) or die(mysql_error().'<p>'.$query2.'</p>');
$num_images = 0;
while ($image_row =mysql_fetch_array ($result) )
{
<center>
<a href='image.php?Id=$image_rowїid_files]' target="_new">
<img src='$path_to_thumb/$thumb_file_name' height="$displayheight" width="$displaywidth" border="1">
</a>
</center>
}please advise
and thank you