> 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
