$query = "
SELECT extra.extra, extra.extra_pay
FROM result_extra
INNER JOIN result
ON result_extra.result_ID = result.ID
RIGHT JOIN extra
ON result_extra.extra_id = extra";
$sql = mysql_query($query) or die('MySQL error: ' . mysql_error());
while($sql_result = mysql_fetch_assoc($sql)){
echo "<pre>";
print_r($sql_result);
echo "</pre>";
}
Array
(
[extra] => Extra1
[extra_pay] => 50
)
Array
(
[extra] => Extra2
[extra_pay] => 30
)
There are tree matching rows in result_extra and result. If i put in more matching rows I still only get two rows.
