MySQL Loop

[AzN]

I'm having trouble with a mysql loop.

I have three tables.

I need to query the first table, then it queries the second table, and it needs to loop the data from the third table.

Here is how I do it.

$id = $_GET['id'];

SELECT * FROM table_1 WHERE id='$id'

$row2 = $row['id_2'];

SELECT * FROM table_2 WHERE id='$row2'

$row3 = $_row['id_3'];

This is where I would use the while() loop and SELECT * FROM table_3 where id='$row3'

BUT..... it only prints out the FIRST value even thought I put a mysql_fetch_array loop.

Any help is appreciated.
Thanks!

 

[Peter]

could you post more code so we could see.

Also have you tried echoing out the last query to see if it as expected then running it through phpmyadmin too see how many results are actually returned.

 

[Dan]

Why would there be more than one row if you are selecting by id?


You could try mysql_fetch_assoc instead.

while ($row = mysql_fetch_assoc(mysql_query("SELECT * FROM table_2 WHERE id='$row2'"))) { ... }