retrieving images from database in thumbnail form

[tagz017]

hi guys.. need your help for retrieving selected images from the database and display it in thumbnails.. thanks

[flagbarton]

<?
mysql_connect("localhost","root", "");
mysql_select_db("dbname");
$query = "SELECT Pics from tblPic";
$result = mysql_query($query);
echo '<table>';
while ($r=mysql_fetch_array($result))
{
$pic = $r;
echo '<td><img src="'.$pic.'" width="32" height="32"></td>';
}
echo '</table>';
?>

[flagbarton]

<?
mysql_connect("localhost", "root", "");
mysql_select_db("dbname");
$query = "SELECT Picture FROM tblPics";
$result = mysql_query($query);
echo '<table>';
while ($r=mysql_fetch_array($result))
{
$pic = $r;
echo '<td><img src="'.$pic.'" width="32" height="32"></td>';
}
echo '</table>';
?>