Doesn't really seem to be anything wrong with the query, but try:
if(!$numresults=mysql_query($query)){
// error occurred so print the mysql error message
echo("DB Error Occurred: " . mysql_error());
}
else{
$numrows=mysql_num_rows($numresults);
// ... continue with rest of your code
}

instead of just:
$numresults=mysql_query($query);

At the very least, this will narrow down your scope for errors.