[PHP] Variable Question

[dekuro]

Hello,

what is the solution for checking whether mysql_query was successful or not? For example, when I $result=mysql_query( "CREATE TABLE....." ); and afterwards do if ( $result ) { // was successful }:

Will this code in the if-condition repeat the query or just check if the variable is not empty? What about this: if ( !$result ) { // not successful }

thx

[freddydoesphp]

$result will be true if the query was successful and false if the result wasn't.

[Kevin Yank]

So if ($result) { ... } executes the code in braces if the query was successful, and if (!$result) { ... } executes the code in braces if the query failed. Neither of these re-do the query -- the query is performed by mysql_query(), and the result is stored in $result, along with an indication of success or failure (which the above code fragments use).

[Vinay]

i prefer using mysql_num_rows() and mysql_affected_rows() so if its 0, i know something is wrong ... because, the query will FAIL only when the query is incorrect

--------------------
SitePoint Community Advisor
myPHPhost: when you want something MORE from a host

[Kevin Yank]

Yep, Vinay. It really depends on the circumstace. Some of my queries are expected not to affect any rows sometimes, but I still check them for error. Others I'll often check for error and then check for rows affected.

I always check for error, though, because if done using the 'or' operator there is extremely little overhead and it's a nice fail-safe.