PHP MySQL loop in loop

[j milo taylor]

Hi everyone,

I've got a real headache here:

mysql_select_db($database_immapp, $immapp);
$recordID = $_GET['recordID'];
$query_rs_country = "SELECT

*

FROM artist

LEFT OUTER JOIN artist_nodes
on id_artist = artistID_artist_nodes

WHERE location_id_artist = $recordID ORDER BY 'year_artist'";
$rs_country = mysql_query($query_rs_country, $immapp) or die(mysql_error());
$row_rs_country = mysql_fetch_assoc($rs_country);
$totalRows_rs_country = mysql_num_rows($rs_country);

which I need to (somehow) JOIN to nodes table
on id_node = nodeID_artist_nodes

as is i get 334 records back, it should be 34.

each node.node_node then needs to be looped through within each record for $row_rs_country.

I spent a couple of days on this and am getting nowhere.

Can anyone help?

Cheers,
Milo

[coopster]

INNER JOIN instead of LEFT JOIN?

[j milo taylor]

Nope,

INNER JOIN does the same

:-(