RE: [PHP-DB] Using an array(-ish) in SQL queries

so close.... heh ... thanks mate :) and whether they're to actually be deleted, that depends on the application ... I have a few different where I use it. Rene At 02:13 03-11-2004, Bastien Koert wrote:

DELETE FROM the_table WHERE ID IN(1,2,3,4,5,6) will work just fine. The trick is to be sure that those records indeed are to be deleted. I prefer to mark the record as deleted for a time before permanent deletion. That way its recoverable should something really bad happen. bastien

-- Rene Brehmer aka Metalbunny If your life was a dream, would you wake up from a nightmare, dripping of sweat, hoping it was over? Or would you wake up happy and pleased, ready to take on the day with a smile? http://metalbunny.net/ References, tools, and other useful stuff... Check out the new Metalbunny forums at http://forums.metalbunny.net/