Is it possible to fetch from two arrays simultaneously?

[JeditL]

Hello

 

I got 2 mysql queries in my code. I need them both because the second one needs a value from the first one that the query succeeds. I would like to print the data from both of the queries at the same time.

 

$query1="SELECT...";

$query2="SELECT...";

 

$result1=mysql_query($query1);

$result2=mysql_query($query2);

 

while ($row = mysql_fetch_array($result1)    {  //how to add both of the results here?

        echo $row['name'];

        echo $row['color'];

}

 

How to fetch from both of the result arrays in same while loop? Is it even possible?

 

Thanks again to everyone replying.

[wildteen88]

This is bad code practice. Post your queries here. I assume you're querying two different tables. MySQL is able to pull data from multiple tables within one query using JOINs.