[PHP] inserting date() into MySQL

2003-03-04 Thread Charles Kline
If I am going to use date('U') to insert an epoch timestamp into a mysql table, what is the appropriate field type to use? thanks charles -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] inserting date() into MySQL

2003-03-04 Thread 1LT John W. Holmes
If I am going to use date('U') to insert an epoch timestamp into a mysql table, what is the appropriate field type to use? Integer. ---John Holmes... -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP] Inserting DATE in mySQL!!

2001-03-05 Thread Thomas Edison Jr.
I'm using the following code to insert date into my mySQL table named "Booking". I've created variables that store the date with dashes "-" seperating them. But it's not working. It's giving me an error on the $SQl line. following is the code : ?php $db =

Re: [PHP] Inserting DATE in mySQL!!

2001-03-05 Thread Miles Thompson
What field type are you using to store time? Echo your $sql and compare it to MySQL's documentation on the time column and how you have defined the field. Miles At 03:51 AM 3/5/01 -0800, Thomas Edison Jr. wrote: I'm using the following code to insert date into my mySQL table named "Booking".

Re: [PHP] Inserting DATE in mySQL!!

2001-03-05 Thread CC Zona
In article [EMAIL PROTECTED], [EMAIL PROTECTED] ("Thomas Edison Jr.") wrote: I'm using the following code to insert date into my mySQL table named "Booking". I've created variables that store the date with dashes "-" seperating them. But it's not working. It's giving me an error on the

Re: [PHP] Inserting DATE in mySQL!!

2001-03-05 Thread Hardy Merrill
CC Zona [[EMAIL PROTECTED]] wrote: In article [EMAIL PROTECTED], [EMAIL PROTECTED] ("Thomas Edison Jr.") wrote: I'm using the following code to insert date into my mySQL table named "Booking". I've created variables that store the date with dashes "-" seperating them. But it's not