I want to add an amend functionality to my system. Therefore i need retrieve data from 2 different tables and display it in a single form.
account_details ( account_number, full_name,____)
account ( account_number, name_with_initials,____)
When i try to retrieve data from these 2 tables,output comes as an empty form.Can anyone correct my query.
$sql =sprintf("SELECT account_details. full_name,phone_number,address,gender,date_of_birth,account.name_with_initials,account_type,fd_period"." FROM account_details,account"." WHERE account_details.`account_number`='%s'", mysql_real_escape_string($_POST['account_number']) );