I have a small problem with a MYSQL select query involving an INNER JOIN. Both tables that I'm joining have a field that have identical names. So when I use
$array = mysqli_fetch_array($result,1); $field = array['fieldname'];
it returns the wrong value from the wrong table.
Is there any way around this?