I am utterly confused. I have an sql query that is returning all rows except the first record of the matches.
<?
$q6 = "select * from pictures where pictures.MemberID = '$_SESSION[MemberID]'";
$r1 = mysql_query($q6) or die(mysql_error());
echo "<input type=text name=\"caption\" value=\"Enter Caption - e.g. At Club in LA\" size=45 onClick=\"this.value=''\"><br><input type=file name=\"images[]\" size=20><input type=\"submit\" name=\"s1\" value=\"Upload\"><br><br>";
if(mysql_num_rows($r1) > '0')
{
while($rowp = mysql_fetch_array($r1)) {
echo "<center><a href=#><img src=\"../images/userpics/thumbs/$rowp[uimage]\" alt=\"$rowp[caption]\" border=0></a><br><a class=RedLink href=\"photoupload.php?remove=true&id=$rowp[id]&file=$rowp[uimage]\">delete this image</a> | <a href=\"photoupload.php?default=true&file=$rowp[uimage]\">Set As Default</a></center><br>";
}
} else {
echo "<i>You Have No Photos</i>";
}
?>
Database dump for my pictures table below (e.g. there are 5 records with MemberID '1' below. But when I run my above query I only get 4 records?!
1 1 1175487294_nc4.jpg 0
45 1 1179785317_meglory.jpg Me in Glory! 0
3 1 1174952851_nc2.jpg 0
4 1 1174952844_nc1.jpg 0
5 1 1165863603_christmas.jpg 0
6 41 1179464687_My face.jpg 0
7 10 1178653821_IMAGE_00027.jpg 0
8 10 1178653749_DSCN00041.JPG 0
9 10 1178653730_charlesmissypainting.jpg 0
10 10 1178578978_firstabstract.jpg 0
11 10 1178578942_92acura.jpg 0
12 10 1178578913_thebeach.jpg 0
13 10 1170017156_tribal palm tree.jpg 0
14 10 1165616653_picmeoct06crop1.JPG 0
15 10 1165539633_DSCN4378.JPG 0
16 11 1164830164_myspacesantaclose.JPG 0
17 11 1164830164_Gummy Worm Crawl.JPG 0
18 11 1164830164_lilemo.JPG 0
19 14 1166463223_382864_1161311349.jpg 0
20 14 1166463202_382864_1164676241.jpg 0
21 14 1166463117_shiloh8_3_f1.jpg 0
22 15 1166817679_newhairsmall.jpg 0
23 19 1173718043_faceshot.jpg 0
