Two conditions in a while loop 1

[Phailak]

Hail,

Can you put two conditions in a while loop? Reason I want to know is I have two arrays I want to loop through, only stopping the loop when BOTH are eof.

Something like:

$queryH="SELECT * FROM Goals";
$resultH=mysql_query($queryH);
$queryA="SELECT * FROM Assists";
$resultA=mysql_query($queryA);
while($rowH=mysql_fetch_array($resultH) OR $rowA=mysql_fetch_array($resultA))
{
*** code here would check if either is eof, if not then it would print in a table, $queryH in 1st column, $queryA in column 2
}

 

[sleipnir214]

That while() only has one condition. It's a complex condition, but only one.

Since you're using the operator OR instead of ||, it should work. It's not necessarily very readable, though.



Want the best answers? Ask the best questions! TANSTAAFL!

 

[Phailak]

It doesn't work, I get an error on this line:

while($rowH=mysql_fetch_array($resultH) OR $rowA=mysql_fetch_array($resultA))


The error is (shows twice as if each statement is wrong???):

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in C:\Program Files\wamp\

http://www\LSHL\results.php

on line 71

 

[sleipnir214]

Then your SQL is wrong.

mysql_query() will only return a MySQL result resource when it can successfully run a SELECT query.

See section 1.5 of faq434-2999



Want the best answers? Ask the best questions! TANSTAAFL!

 

[Phailak]

You're right, I changed the query and it worked, thanks!!!