[eluser]binbink[/eluser]
the mentioned solution works fine for me when the procedure returns multiple rows.
$result = $this->mydb->Query($sql);
but what if routine does not return any data? e.g. it only updates two tables with the specified data.
if I use $this->db->query I see
Error Number: 2014
Commands out of sync; you can't run this command now
if I use
$this->mydb->Query($sql);
I do not see any error messages; but the data is not updated. NOTE: there should not be an issue with routine itself since if I print the query in question and try to execute this in MySQL Workbench - tables are updated correctly.
Let me know if there are any known/possible solutions for this.
Thank you
