How to delete a row in mysql table

[deeablos]

Hello
I want to know how to delete rows in mysql tables
I want to delete row 27 to 30 in one of my tables

[bastien]

1. create a query to find the rowID of each row to be deleted and mark it in a separate column with a y/n (check box) then call a script to delete the rows

2. just delete the rows with a script using the primary key (unique row identifier)

ie ($sql = "delete from table where rowID in (27,28,29,30)";

3. create another column called available and tick this to yes (via a check box)...what happens here is that you don't delete any data, but and queries run on the table look to only include those items ticked as available...you can turn off the by removing the checkbox tick in an admin form...(my personal favorite...never let anyone have delete access to your data...better security)

hth