Delete

[mysql_query]

$query="DELETE table WHERE something='$something'";

Hi. I'm getting a MySQL error. Something is worng. Can someone help?

Thanks.

[weekender]

i think to delete a table you would just use

$query = "DELETE TABLE tablename";

whereas to delete a row, you need to be more specific, hence

$query = "DELETE FROM tablename WHERE something = '$something'";

[mysql_query]

Yep, that works.

"FROM" was the missing touch.

Thanks.