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(
$arraymysql_fetch_assoc($results))
    {
        echo 
'<br>';
        print 
$array['School Name'];
    }
}
else{
        echo 
"no results found";