[RESOLVED] Want to DELETE row FROM multiple tables

[SDSU]

Hello. Thanks for looking.

I'm looking to delete a single row from multiple tables where they all share a common column name, primaryKey, and a common value - $POST_[primaryKey]. Here is the code:

$query="DELETE FROM assetinfo, emplhistory, income, newuser, preliminfo, primarydata, reoinfo, residencehistory WHERE primaryKey='$_POST[primaryKey]'";

		$result=mysqli_query($connection, $query) or die (mysqli_error($connection). "					             <br> Could't run DB Query to Delete Borrower");

And here is the error msg I'm getting:

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 'WHERE primaryKey='jarreola2'' at line 1
Could't run DB Query to Delete Borrower

Is my query valid? Any other ideas on how to delete a row from multiple tables? Thanks!

[rulian]

it may be failing at one specific table, try running the delete sql for each table individually first see if they all go through

[SDSU]

rulian wrote:

it may be failing at one specific table, try running the delete sql for each table individually first see if they all go through

Good point, thanks. I'll try that in a few hours when I get home.

So the syntax should work assuming there are no problems with the components of the query?

[SDSU]

Hmmm...my queries worked fine when broken up into individual queries as such:

$query="DELETE FROM tablename WHERE primaryKey='$_POST[primaryKey]'";

		$result=mysqli_query($connection, $query) or die (mysqli_error($connection). "					             <br> Could't run DB Query to Delete Borrower");

So I'm thinking the query syntax was not valid on my original post.