Warning: mysql_fetch_assoc(): supplied argument is not a valid

[bcode]

        I can't get this to work I don't know what is wrong I have checked the table names and checked everything with print_r and the Mysql statement is printing right but to no avail.

 

       

$names = explode(" ",$searchTerm);
$datauser = "SELECT * ";
$datauser .= "FROM users ";
$datauser .= "WHERE firstName = $names[0] AND lastName = $names[1] ";

$resultuser = mysql_query($datauser);		
$listuser = mysql_fetch_assoc($resultuser);

$contractUser = $listuser['contract'];

[fareedreg]

check is the table empty?

[PFMaBiSmAd]

Empty tables and queries that return zero rows DON'T cause mysql_ function errors.

 

Your query failed to execute due to an error. In just looking at it, you need some single-quotes around '$names[0]' and '$names[1]' in the query to make those values string data instead of column names.

[bcode]

Thank you for the single quotes I can't believe that was what I was missing I was pulling my hair out over this.