MrFahad
asked on
2 quires at same time
Hello,
i want to do run to quires at the same time here is the code:
here is the error:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'INSERT INTO transaction ( PropertyName, CustomerName, dateOfTransacti' at line 6
i want to do run to quires at the same time here is the code:
here is the error:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'INSERT INTO transaction ( PropertyName, CustomerName, dateOfTransacti' at line 6
$query = "INSERT INTO customers (
PropertyName, CustomerName, CustomerAddress, CustomerAge, CustomerGender, CustomerNumber, CustomerNationality, dateOfTransaction, description
)VALUES (
'{$PropertyName}', '{$CustomerName}', '{$CustomerAddress}', {$CustomerAge}, '{$CustomerGender}', {$CustomerNumber}, '{$CustomerNationality}', '{$dateOfTransaction}', '{$description}'
)
INSERT INTO transaction (
PropertyName, CustomerName, dateOfTransaction
)VALUES (
'{$PropertyName}', '{$CustomerName}', '{$dateOfTransaction}'
)";
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Oops my mistake, my above code works with same table structure.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Open in new window