Code: Select all
$query = '
select query;
select query;
update query;
update query;
'
$conn->multi_query( $query );
$error = $conn->error;
if( $error == "" ){
$query = 'another update query'
$conn->query( $query );
}Code: Select all
Commands out of sync; you can't run this command nowEDIT: the queries are working fine when they are run using mysql clients/tools but does not run from PHP especially the last update command does not get executed while others are I guess
what do you think is the problem and how can I solve it? Any idea is appreciated.