I am trying to pull all rows from a mysql database where their `date` = $date

But it is not pulling all of them, I have 3 in database, it pulled 2, then I added more to make 5, and it pulled 3. I don't get it.

Here is my code (may not be perfect but it works...)
PHP Code:
while ($row mysql_fetch_assoc($query)) {
                        echo 
"<p id=\"$pid\">&nbsp;</p>\n";
                        echo 
"<div class=\"wordDef\">\n";
                        echo 
"<div class=\"gototop\">\n";
                        echo 
"<p onClick=\"window.location='audio.php#top';\">^ top ^</p></div>\n";
                          echo 
"<h4 class=\"audioServiceTitle\">";
                        switch(
$month){
                            case 
1: echo "January";
                            break;
                            case 
2: echo "February";
                            break;
                            case 
3: echo "March";
                            break;
                            case 
4: echo "April";
                            break;
                            case 
5: echo "May";
                            break;
                            case 
6: echo "June";
                            break;
                            case 
7: echo "July";
                            break;
                            case 
8: echo "August";
                            break;
                            case 
9: echo "September";
                            break;
                            case 
10: echo "October";
                            break;
                            case 
11: echo "November";
                            break;
                            case 
12: echo "December";
                            break;
                        }
                        echo 
$day$year4</h4>\n";
                        echo 
$row['name']."\n";
                        echo 
$filename."_".$row['type']."\n";
                        
                    } 
// END WHILE
                
if($count>0){
                
mysql_data_seek($query,0);
                } 
The mysql_data_seek doesn't seem to affect it either because I have other dates with rows, and it doesn't pull those at all.
There is code that is not shown, if you need that, let me know.

Thanks.