Here is my problem, It only retrieves one entry insted of all of them from the database.
here is my code.
$sql = "SELECT cd.customer_name, c.first_name, c.last_name, cd.mobile_number, cd.model, cd.handset_supplied, cd.end_contract, cd.IMEI
FROM customer_details cd
LEFT JOIN customer c
ON c.customer_name = cd.customer_name
WHERE c.account_number = '" . $val . "'";
It is only returning one results when i have two mobile numbers in the database with the same account number please help