PHP SQL result problem

[slash_gnr3k]

i have the following code:

$getunitid = @mysql_query("SELECT unitid FROM units WHERE name = '$newingname'"); 

                        if(!$getunitid) 
                        { 

                                echo'<p>fail ' . mysql_error() . '</p>'; 

                        } 

                        while ($row = mysql_fetch_array($getunitid)) 
                        { 

                                $unitid = $row['unitid']; 

                                echo"test ok!"; 
                                echo"$unitid";  
                        
                        } 

what this code should do is run a select statement and then pass the output to a variable and display it.
The query runs fine as fail is not outputted. however the next part is the problem. test ok is not out put. therefore i think there must be something wrong with my statement but i dont know what. can anyone heklp?
thanks[/php]

[Mittineague]

Try running the query without the error suppression, the "@"
It may be that $getunitid is something, just not what you think it should be.

[wheeler]

is it returning 0 rows?