SQL syntax

[Chris_Evans]

Hi there,
Got a small problem with my SQL syntax:

"DELETE FROM categories,shops USING categories,shops WHERE categories.id='".$form_CATEGORYID."' AND categories.owner='".$form_CATEGORYID."' AND shops.catid='".$form_CATEGORYID."'"

I can't spot it - I've tried without the "USING categories,shops" but that doesn't make any difference.

I get the following error.

You have an error in your SQL syntax near 'shops USING categories,shops WHERE categories.id='71' AND categories.owner='71' ' at line 1

Thanks in advance,

Chris Evans

[Weedpacket]

I think you can only DELETE records; and a record can only be in one table. So it's probably not good SQL to name two tables to delete from in one DELETE statement.

[Chris_Evans]

Ah, ok. Thanks. 🙂