MySQL query

[Perad]

This isn't working, i am not sure i quite grasp the concept of deleting from multiple tables.

Basically i want to delete from news the record where id=$id and from news_comments where news_id=$id

Could someone help me fix this query please.

Thanks

[code]"DELETE FROM news,news_comments WHERE news.id='$id', news_comments.news_id=$id"[/code]

[wildteen88]

Try this:
"DELETE FROM news, news_comments WHERE news.id='$id' AND news_comments.news_id='$id'"

[Perad]

Nope the error messages comes back with

Could not connect to MySQL: 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 news.id='10' AND news_comments.news_id='10'' at line 1

[fenway]

I assume your version supports multi-table deletes?

[toplay]

Perad, notice that in wildteen88 post there's single quotes around the $id variables. The error you posted seems to indicate that you're missing a single quote (on the right) at the second $id variable.

... right syntax to use near 'WHERE news.id='10' AND news_comments.news_id='10'' at line 1

should be:

... news_comments.news_id='10'