I'm creating a web site that allows people to upload a photoalbum. However, I don't know how to have the pictures flip through all pictures they've uploaded. Currently, I get the same picture a bunch of times.
Here's my coding so far:
$pictures_query = "SELECT * FROM pics WHERE CUserName='$CUserName'";
$all_album_pics = mysql_query($pictures_query);
print "<table>
<TR>";
for($i=0; $i<=$total_rows; $i++)
{
$object = mysql_fetch_object($all_album_pics);
print ("<TD>
<img src=\"$filedir/$PDescription.jpg\" width=\"50\" height=\"70\">
</td>");
}
print "</tr></table>";
Thanks,
Mike