Jump to content

Archived

This topic is now archived and is closed to further replies.

Perad

MySQL query

Recommended Posts

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]

Share this post


Link to post
Share on other sites
Try this:
"DELETE FROM news, news_comments WHERE news.id='$id' AND news_comments.news_id='$id'"

Share this post


Link to post
Share on other sites
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

Share this post


Link to post
Share on other sites
I assume your version supports multi-table deletes?

Share this post


Link to post
Share on other sites
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'


Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.