[SOLVED] MySQL Errors

[jjacquay712]

Ok.... this one is really simple but i don't know what to do. When i do a query like this:

 

$resource = mysql_query("whatever");

$result = mysql_result($resource, 0, 'username');

 

and it doesn't get a result it displays this error: Warning: mysql_result(): supplied argument is not a valid MySQL result resource.

 

how do i do it, so that if it doesn't find anything, it doesn't give an error? and $result == "";

[DarkWater]

It means the query was invalid, not that it returned no rows. You should add (albeit rudimentary) error checking to your query:

 

$resource = mysql_query("whatever") OR die(mysql_error());

 

Also, don't use mysql_result().

[jjacquay712]

i cant echo a mysql_query(), i need to echo the data