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() 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

[PHP] inserting date

2003-01-22 Thread Diana Castillo
When I insert a date into Mysql it has to be in year/month/day format or else it wont go in right. how do I convert my date variable which is in month /day /year format into year/month/day format? -- Productos de salud: http://www.nvtechnologies.com/hgh -- PHP General Mailing List (http://www

Re: [PHP] Inserting DATE in mySQL!!

2001-03-05 Thread CC Zona
In article <[EMAIL PROTECTED]>, [EMAIL PROTECTED] (Hardy Merrill) wrote: > > or die ("MySQL says: " . mysql_errorno() . " " . mysql_error() . "\nPHP > ^ > > Just a technicality, but I think I remember this to be > mysql_errno(). But CC is right - in yo

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. > > Bu

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 th

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". I

[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 : ?? Cheers, T. Edison jr. = Rahul S. Johar