MySQL error handling for query that might not return anything

Question

I have this MySQL query that has to run when the page is loaded, however not all users have the data required to return anything, this gives out a massive error.

Is there anyway i can handle this error so when the query doesn't return anything, i can just return say "0" in the function. Here is the code;

function getTimesUp($email) {   
    $query1 = mysql_query("SELECT uptime FROM info WHERE user='$email'");
    $uptime1 = mysql_result($query1, 0);

    return $uptime1;
}

Thanks!

Biotox · Accepted Answer · 2012-01-20 23:56:04Z

1

Check the query to see if it returned a 0 number of rows.

function getTimesUp($email)
{   
  $query1 = mysql_query("SELECT uptime FROM info WHERE user='$email'");

  if(mysql_num_rows($query1) == 0)
  {
   return 0;
  }
  else
  {
    $uptime1 = mysql_result($query1, 0);
    return $uptime1;
  }
}

edited Jan 20, 2012 at 23:56

answered Jan 20, 2012 at 23:50

Biotox

1,61111 silver badges15 bronze badges

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

Comments

Explosion Pills · Accepted Answer · 2012-01-20 23:49:55Z

0

You could just check whether mysql_num_rows() is greater than zero.

answered Jan 20, 2012 at 23:49

Explosion Pills

192k56 gold badges341 silver badges417 bronze badges

Collectives™ on Stack Overflow

MySQL error handling for query that might not return anything

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related