php-general | 2001032

[PHP] RE: [PHP-DB] Best way to check if a query succeeded From: Boget, Chris (Chris.Boget <email protected>)
Date: 03/29/01

> i was just wondering what you guys do to check if a wquery
> suceeded or not?
> I know about mysql_num_rows() and mysql_affected_rows(), just
> wondered what
> you guys do?

I do this:

$result = mysql( $dbname, $query );
if(( $result ) && ( mysql_errno() == 0 )) {
  // query was successful
  if( mysql_num_rows( $result ) > 0 ) {
    // do your stuff here...
    
  } else {
    echo "Successful query returned no rows";

  }
} else {
  echo "Query failed: " . mysql_error() . "<br>\n";

}

There is a difference between a "successful query" and
a query that returns 0 rows and should be handled
differently, typically. Depending on what you are doing,
you might not care -- 0 rows = unsuccessful query.
However, in my case, I want to know if a query was
malformed, contained erroneous data that's throwing
mySQL off or whatever. These types of errors will
return 0 rows as well.

Chris