Re: [PHP] Re: how to deal with multiple authors for one book

2009-02-24 Thread Bastien Koert
On Tue, Feb 24, 2009 at 8:59 AM, PJ wrote: > Reinhardt Christiansen wrote: > > > > > > > >> From: PJ > >> To: MySql > >> Subject: how to deal with multiple authors for one book > >> Date: Mon, 16 Feb 2009 17:20:54 -0500 > >> > >> In my db there are a number of books with several authors; so, I

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

2004-11-02 Thread Bastien Koert
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 From: -{