Hi, mates!
The following query acts very strange, it returns only 1 result instead of X...
I might be doing it wrong somewhere
<?php
$query = "SELECT ul_user_id, ul_nick, ul_region_id, up_user_id, up_instrument FROM prn_user_list, prn_user_profile WHERE
(prn_user_list.ul_region_id='". $region ."')
AND (prn_user_list.ul_user_id = prn_user_profile.up_user_id)
AND (prn_user_profile.up_instrument = '". $instrument ."')";
$result = mysql_query($query) or die(mysql_error());
while($row = mysql_fetch_array($result)) {
echo "User: ". $row['ul_nick'] ."<br />";
echo "Region: ". $row['ul_region_id'] ."<br /><br />";
}
}
?>
Tnx in advance!