HELP with mysql_fetch_array

Anon

Hi all

question about how to test for the result of a mysql_fetch_array as the condition of a while loop.

what I want to do is fetch the data from the mysql resource, and then either get a message that it is empty (no data in row), or if there is data, do stuff with the data.

example:

$stmp=mysql_query(select * from mytable where thevalue=1);

while ($row=mysql_fetch_array($stmp)){
foreach ($row as $data)
{
do some stuff
}

}#end of the whileloop

however, if the msql query produces nothing (eg there are nothing in mytable that matches thevalue) what is the returned value of $row?

I know one way to fix this, but it requires another mysql call, and I'd rather not have to add another mysql call just to test if there is data or not.

eg:

if (mysql_fetch_array($stmp){
do the above code
}else{
echo "no data returned";
}

or something like this.

any ideas or help on this would be much appreciated.

thanks

eric

Anon

however, if the msql query produces
nothing (eg there are nothing in
mytable that matches thevalue) what is
the returned value of $row?

The foreach of $row will never be reached if there no data since it is within the "while" loop. mysql_fetch_array returns false when there are no more rows to fetch (or none to begin with).

Jack

kailien

if ( mysql_fetch_row($stmp) == 0 )
{
echo "Sorry there are no records!";
}

may be the above will help

Kai

Anon

Thanks for the responses.

Jack. I don't know why, but even if the returned $row has no data (and is therefore "false"), my code still executes the while!!!

Kai. Thanks...that is the work-around I had thought up already.

Just wondering how to do it without having to call mysql_fetch_array 2 times (1 to test if data exists, and 1 to go through the data if there is any...

sigh..

eric

Anon

The "while" should definitely not execute. Post your real code and maybe there is something else messing it up. There's no bug in PHP here as I use something similiar all the time.

Jack