So my query and everything is working correctly...the problem I have though is when I display the results I with this loop no matter if there are any actual results or not the results variable has the value "resource id #2" stored when it runs so that makes the else statement never show even when it should. Anyone have any ideas.
PHP Code:
if($results)
{
while($array= mysql_fetch_assoc($results))
{
echo '<br>';
print $array['School Name'];
}
}
else{
echo "no results found";
}