delete

[chili5]

This is probably a really silly question but when I run this sql query:

$sql = "DELETE category_id, category_name FROM categories WHERE category_id='" . sanitize($_POST["cbxCategory"]) . "';";

It only deletes whatever is in category_name in the row not the entire row. Why? Shouldn't it delete the entire row?

[Orjan]

Well, you specify it to delete columns. if you do DELETE FROM.. it will do the row.
I didn't know you could delete columns like that :-)

[chili5]

You know what I feel really stupid. There was no problem with my sql code because the two columns above are the only columns in the table.

The problem was my form was sending the POST data to the wrong page for processing.

[Orjan]

oh.. no wonder why...