Re[2]: [PHP] confused big time

2004-04-07 Thread Richard Davey
Hello Mark, Wednesday, April 7, 2004, 6:35:31 PM, you wrote: MA> But what about MsSQL, Oracle and postgres to name a few. I have worked MA> on a few projects where you read from one db and load into another db. MA> Dates then become the spawn of satan. But the MySQL syntax for insert is not the

Re[2]: [PHP] confused big time

2004-04-07 Thread Richard Davey
Hello Mark, Wednesday, April 7, 2004, 6:19:31 PM, you wrote: RD>> That .1% of the time being when you need to insert a value as now() ? RD>> (which will break the string check as it'll wrap it with '' which will RD>> cause MySQL to insert -00-00 00:00:00) or if it's an enum field RD>> with a

Re[2]: [PHP] confused big time

2004-04-07 Thread Richard Davey
Hello Mark, Wednesday, April 7, 2004, 5:16:04 PM, you wrote: MA> it builds the sql statement for you. It covers 99.9% of the inserts MA> your likely to need. I use an update and insert function like this all MA> the time. :-) That .1% of the time being when you need to insert a value as now()