Error in PHP using if() on a MYSQL result containing no rows

Question

EDIT: Just to clarify, the query is correct - there are zero rows - the problem I am having is how to handle that in the PHP with the IF basically I am iterating through rows (10 of them) some will have some data for the query and some won't. The page falls over when a row doesn't. Does that make any sense?

I know I'm doing something inherently wrong and I am sure the solution is simple...

MySQL query brings back ZERO rows;

SELECT * from tresults WHERE date = 'MAY2012'

I then have some PHP code as follows:

if($row = mysql_fetch_array($result)){
    // do something
}

Now, as the query brings back ZERO rows, the page falls over on the IF statement...what am I doing wrong....

@Vague - yep, I'm sure it is correct - what I need to do however, is manage it so the page doesn't fall over - if that makes sense? How does one deal with this? Any suggestions? Thanks. — Homer_J
– Homer_J, Commented Feb 24, 2012 at 10:30
@Devart - the DATE field isn't the issue, the query is running correctly and as it should. The problem, I think is the way I'm handling (or not) the situation in PHP. — Homer_J
– Homer_J, Commented Feb 24, 2012 at 10:30
If you do not care if query returns any rows, you do not need an if statement.. — gintas
– gintas, Commented Feb 24, 2012 at 10:33

SimonMayer · Accepted Answer · 2012-02-24 10:35:37Z

2

Check for the number of rows using mysql_num_rows()

if(mysql_num_rows($result) > 0){
  $row = mysql_fetch_array($result);
}

Or use while - note this will run for every row, if your query returns more than one row

while($row = mysql_fetch_array($result)){
  // do something
}

answered Feb 24, 2012 at 10:35

SimonMayer

4,9655 gold badges35 silver badges46 bronze badges

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

1 Comment

Homer_J Over a year ago

Thanks @simonmayer - this is where it causes me a problem - I need it to be IF and not WHEN :( - I think I'm going to have re-code my page.

tofwiz · Accepted Answer · 2012-02-24 10:40:51Z

0

$result = mysql_query("SELECT * from tresults WHERE date = 'MAY2012'");

while ($row = mysql_fetch_array($result))
    {
        //do stuff;
    }

answered Feb 24, 2012 at 10:40

tofwiz

35 bronze badges

Collectives™ on Stack Overflow

Error in PHP using if() on a MYSQL result containing no rows

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