My suspicion is that you are re-using the same result variable, so your original query's results are overwritten with each subsequent result.

Try re-naming your variables like so:



$result = mysql_query("SELECT ...") or die(mysql_error());

while ($array = mysql_fetch_array( $result )) {

$detailresult = mysql_query("SELECT ... ) or die(mysql_error());

$detail = mysql_fetch_array($detailresult);

$userresult = mysql_query("SELECT ...") or die(mysql_error());

$user = mysql_fetch_array($userresult);

print ("$user[2]");

}

Ah yes ! Thanks very much. I'll get the admins to give you the points.