2 queries inside same while statement?

[xwishmasterx]

I am wondering if it is possible to create 2 queries, and use 1 while statement?

Something like:

 

while (($row = mysql_fetch_array($rs_getevent)) && ($row = mysql_fetch_array($rs_getevent2))) {

 

Is something like this possible?

 

[xyph]

Why not test it yourself?

[xwishmasterx]

I have tried that code, that didn't work, but it might be possible why I ma asking. The code is just to show what I am trying to achieve.

[spiderwell]

in short it wont work as the second dataset will replace the first as you pass it to the same variable.

 

are you able to use a JOIN statement in your sql to get it all in one go?

 

 

[xyph]

And if a JOIN isn't possible, just use two loops.

 

One loop doing twice the work as two won't save you much processing power. Just a little bit of code. This snippet from the php.net website even dumps the result into an array in a single line.

 

Daniel Chcouri - 333222 +A-T+ gmail 02-Apr-2009 11:45

Fetching all the results to array with one liner:

<?php 
$result = mysql_query(...); 
while(($resultArray[] = mysql_fetch_assoc($result)) || array_pop($resultArray)); 
?>

[spiderwell]

nice i didn't know you could do that!

 

 

[xwishmasterx]

Thanks for the suggestions. As being fairly new to this I'm getting more and more confused lol. I'll see if I can make some of this work, otherwise I'll reply with the code I have so it is more clear what I am trying to achieve (there's usually a simple answer to my questions)

[xyph]

Good luck. Feel free to ask about specific parts of code that you don't understand. If the PHP manual doesn't explain it well, volunteers like us will try to explain it in a different way for you

[xwishmasterx]

After a look at this, I simply have no idea what to do with it 

 

So here are some more info; I am trying to list some events by date. My problem is listing 2 events happening the same day where a "variable" can be 2 things.

 

 

As picture above shows team with id "21" is both attacker and defender on same date. (disregards war_ended date)

 

When showing the events, It should show the date, the defending team name if any, and the attacking team if any.

 

my query right now is:

$sql_getevent = "SELECT DATE(war_started) AS war_started, attacker_name, defender_name, won, lost FROM teamwar_info 
WHERE attacker=".$_GET['t']."
ORDER BY DATE(war_started) DESC ";
$rs_getevent = mysql_query($sql_getevent);

 

This will show the date the right team name of the team being attacked.

The next column should show the team name of the team ATTACKING (on picture it should be "Black Beards Crew" as this team is attacking the team with id 21.

 

Using above picture: Assume our team has id 21. The event list should show date: 2011-5-10, attacking (the team WE attack): Jack Sparrow, the team attacking US: Black Beards Crew.

 

How can I do this?

 

(I am sure this is confusing, so please ask and I'll try to further explain.)