simple sql query help

[Zaphan58]

Im trying to delete a record from my sql table based on the record id. Heres what I have I cant see whats wrong with it.

$query = "DELETE * FROM news WHERE news_id = $newsid";

Throws me up this error:

Error in query: DELETE * FROM news WHERE news_id =13. 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 '* FROM news WHERE news_id =13' at line 1

 

[Zaphan58]

Nevermind I just needed to remove the *

Heres the query if anyone searching has the same problem in the future.

$query = "DELETE FROM news WHERE news_id = $newsid";