delete by index number

[gabriel]

hello
I have a form which has already processed a "SELECT * FROM Equip WHERE `ClientName` = 'CName'". I have a result set. I wnt to know if there is a way to delete from this result set certain indexes. Such as the first and third records in this set ? I am using MySQL with php. -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --

[savannah]

gabriel
You would have to go through the records one by one, identifying which ones meet your criteria for deletion, and either execute a "DELETE FROM equip WHERE fld=123" for each one, or assemble a delete query as you go, and execute the query at the end, something like "DELETE FROM equip WHERE fld IN (123,456,789)".

its easy -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --