I have mode no modifications to a mySQL query that has been working for years but now, it returns no errors but also returns no rests no matter what I search. Any help would be appreciated

if  ($search)      //  perform  search  only  if  a  string  was  entered. 
     { 
       mysql_connect("localhost", "ners_database", "pass")  or  die  ("Problem  connecting  to  Database"); 
               
       $srch= "$search"; 
       $query  =  "SELECT  *  FROM areas WHERE ZIPcode  LIKE  '$srch'  ||  City  LIKE  '$srch'  ||  Abbrev  LIKE  '$srch'  ||  State  LIKE  '$srch'  ||  County  LIKE  '$srch'"; 

       $result  =  mysql_db_query("nersreco_ners", $query); 

       if    ($result) 
       { 
       echo  "Here are your search results:<br><br>"; 
       echo  "<table  width=450px  align=center  border=1><tr> 
               <td  align=left  bgcolor=#dbecf0><strong>ZIP Code</strong></td> 
               <td  align=left  bgcolor=#dbecf0><strong>City</strong></td> 
               <td  align=left  bgcolor=#dbecf0><strong>Abbrev</strong></td> 
               <td  align=left  bgcolor=#dbecf0><strong>State</strong></td>
               <td  align=left  bgcolor=#dbecf0><strong>County</strong></td>
               </tr>"; 

               while  ($r  =  mysql_fetch_array($result))  {          
                       $zip  =  $r["ZIPcode"]; 
                       $city  =  $r["City"]; 
                       $abbrev  =  $r["Abbrev"]; 
                       $state  =  $r["State"]; 
                       $county  =  $r["County"]; 
                                   echo  "<tr> 
                                               <td>$zip</td> 
                                               <td>$city</td> 
                                               <td>$abbrev</td>
                                               <td>$state</td>
                                               <td>$county</td></tr> 
                               <tr>        <td  colspan=5  bgcolor=\"#ffffff\">$comment</td> 
                               </tr>"; 
               }                                    
               echo  "</table>"; 
         }  else  {  echo  "We apologize, our system is currently unavailable.<br>Please download our Coverage Area booklet or contact us.";  } 
     }  else  { 
     echo  "Search  form was  empty.  <br>  You must enter a keyword to search."; 
     }

Have you looked to see whether your data has changed, or to trace the request?

Yeah I have tested everything... nothing has changed. I think it may have something to do with my host updating their version of mysql? Not sure, hoping someone could spot a problem.

Thanks!

I wouldn't be able to confirm or deny that, but I doubt it's the case. In Microsoft Land, when an update to the core database engine breaks existing code, #1 it will be to more complicated code than what you've posted, usually involving esoteric options and query hints, and #2 you'll get an error message telling you what happened. It's often a cryptic error message, but you'll still get some type of notification.

What did your testing cover, and what did it reveal?