Doesn't the command return 1 or 0 in success or failure?

You may not have a result 

Probably wrong but something like

if (mysql_query($query)) {

} else {

}

or you could die out mysql_query($query) or die ........

On Thu, 29 Mar 2001, Boget, Chris wrote:

> > 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
> 


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to