Misunderstanding mssql_query in the manual

I am apparently misunderstanding the mssql_query entry in the manual. The manual reads:- Returns: A MS SQL result resource on success, *TRUE* if no rows were returned, or *FALSE* on error. From that I believe that if I test result for TRUE I should report a no data available and if FALSE display a system errror So my code reads:- $SQL = sprintf("select a_date, a_time, amnt from register where mac_name = '%s' and message_id = 34 or message_id = 35 order by a_date desc, a_time desc", $MachineNum); $rs = mssql_query($SQL, $link) or trigger_error(sprintf('Query failed: %s', mysql_error()), E_USER_ERROR); if(($rs = TRUE)) {

       trigger_error (sprintf("No data exists for machine %s", $MachineNum),E_USER_ERROR);
       die;
       }

No matter what is entered I always get "No data exists......." Please tell me what I am misunderstanding. -- Regards, Alf Stockton www.stockton.co.za Q: Why was Stonehenge abandoned? A: It wasn't IBM compatible. My email disclaimer is available at www.stockton.co.za/disclaimer.html