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.