looping through multiple arrays

Question

i'm really confused about something and need some advice. i want to be able to loop through 2 arrays at the same time but i can't seem to figure it out.

  $query = "SELECT * FROM `table1`" ;
    $result = mysql_query($query) or die(mysql_error());
    $total = mysql_num_rows($result);

    while($row = mysql_fetch_array($result)){
    $ip = $row['ip'];
    $domain = $row['domain'];
    }

    ..... bunch of code using $ip and $domain variables .....

i was going to use foreach, but i can only do 1 array at a time.

foreach($ip as $aip){
echo "$aip"; // how can i add my $domain array as well? 
}

am i missing something? how can i use both arrays at the same time? sorry for the noob question.

Well in this case you don't need a foreach as far as I can tell, you're already looping through the entire array you get from the mysql query. I'm just confused about where the second loop comes from that you want to do? And what's wrong with doing 1 array at a time? You don't have to, but it's easier to just loop through one at a time like you're already doing. So, I'm still not sure what you want exactly. — leetNightshade
– leetNightshade, Commented May 19, 2011 at 11:14

BenMorel · Accepted Answer · 2011-05-19 11:15:19Z

3

You have to use $ip and $domain directly inside your while() loop:

while($row = mysql_fetch_array($result)){
    $ip = $row['ip'];
    $domain = $row['domain'];

    ..... bunch of code using $ip and $domain variables .....
}

No need for another foreach().

answered May 19, 2011 at 11:15

BenMorel

37k52 gold badges208 silver badges339 bronze badges

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

Comments

Brett Zamir · Accepted Answer · 2011-05-19 11:13:06Z

1

foreach($ip as $key => $aip){
    echo $aip . $domain[$key]; 
}

But this would assume $domain and $ip are actually arrays which from your example does not appear to be the same case (and that they have the same keys and number of elements)...

answered May 19, 2011 at 11:13

Brett Zamir

14.4k7 gold badges57 silver badges85 bronze badges

Comments

bungdito · Accepted Answer · 2011-05-19 11:19:27Z

0

foreach (array_combine($ip, $domain) as $aip => $adomain)

answered May 19, 2011 at 11:19

bungdito

3,6204 gold badges33 silver badges38 bronze badges

Collectives™ on Stack Overflow

looping through multiple arrays

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related