Determine if there was a mySQL error with PHP

Question

All, If I run a query like the following:

 $qry = "Select wrong_column from table_name";
 $result = mysql_query($qry);

If wrong_column doesn't exist then I'll get a mySQL error. In PHP, how can I determine if there was an error from mySQL? If there was an error I'd like it to stop further processing but if there wasn't an error I'd like to get the mySQL results like this:

$resultset = mysql_fetch_array($result);

Would doing something like this work?

if(!mysql_error()){
    $resultset = mysql_fetch_array($result);
}

Any advice on how to do this would be appreciated. Thanks in advance!

Mark Byers · Accepted Answer · 2012-07-05 18:42:10Z

4

how can I determine if there was an error from mySQL?

To see if an error occured you should test the result of mysql_query:

$result = mysql_query($qry);
if (!$result) {
    $error = mysql_error();
    // Handle the error.
}

From the documentation:

For SELECT, SHOW, DESCRIBE, EXPLAIN and other statements returning resultset, mysql_query() returns a resource on success, or FALSE on error.

Emphasis mine.

edited Jul 5, 2012 at 18:42

answered Jul 5, 2012 at 17:27

Mark Byers

844k202 gold badges1.6k silver badges1.5k bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

user1048676 Over a year ago

Would I want it to be !$result or leave it as !result?

Jean-Marie Comets · Accepted Answer · 2012-07-05 17:30:20Z

-1

mysql_query("SELECT foo FROM bar") or exit(mysql_error()); is your best friend =)

answered Jul 5, 2012 at 17:30

Jean-Marie Comets

7062 gold badges7 silver badges22 bronze badges

Collectives™ on Stack Overflow

Determine if there was a mySQL error with PHP

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related