How to delete data in table

[dudejma]

I was wondering how to delete data in a table without going through phpMyAdmin. I would like to be able to push a button and it delete it. Thanks.

[bh]

DELETE FROM table_name WHERE column = x;

[robert_gsfame]

DELETE FROM table_name WHERE column = x;

 

dont forget single quotes

DELETE FROM table_name WHERE column = 'x';

[jskywalker]

if this 'column' is numeric, you will not need those single quotes...

[dudejma]

What would I make 'x' and would I make a form? I'm wanting to have checkmarks for each line of data that I have showing from a table and when I'm done with that information, I'm wanting to check that checkmark and then push the delete button. Thanks.

[fenway]

If you're asking how to write php script to do this, you're in the wrong forum.

[dudejma]

I worded it wrong. Sorry! I meant to say how I'm wondering what I put in 'x'?

[fenway]

Well, that depends what data you'd like to delete.

[dudejma]

Nevermind. I moved some stuff around and got it to work. Thanks.