you are inputting a real dot (.) into e_time
remove it:
"INSERT into events (e_title, e_details, start, end, s_time, e_time) values
('$title', '$details', '$s_year-$s_month-$s_day','$e_year-$e_month-$e_day',
'$stime_hour.$stime_minute', '$etime_hour$etime_minute')";
Sincerely,
Maxim Maletsky
Founder, Chief Developer
PHPBeginner.com (Where PHP Begins)
[EMAIL PROTECTED]
www.phpbeginner.com
-----Original Message-----
From: Shane McBride [mailto:[EMAIL PROTECTED]]
Sent: Friday, April 27, 2001 1:04 AM
To: [EMAIL PROTECTED]
Subject: [PHP] writing a time to mysql????
Here's some code that I am using to get the time that is inout from a form
into mysql. It looks like I may have the format backwartds. Any ideas?
"INSERT into events (e_title, e_details, start, end, s_time, e_time) values
('$title', '$details', '$s_year-$s_month-$s_day','$e_year-$e_month-$e_day',
'$stime_hour.$stime_minute', '$etime_hour.$etime_minute')";
s_time and e_time are thr start and end time of the event.
$stime_hour $stime_minute are the hour and minute fileds from the form.
Any ideas????
- Shane
DISCLAIMER: I am by no means an expert on this, or any other, topic...
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
