RE: [PHP] writing a time to mysql????
| From: | PHPBeginner.com | Date: | Thu, 26 Apr 2001 16:17:02 +0000 |
| Subject: | RE: [PHP] writing a time to mysql???? | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-50475@lists.php.net to get a copy of this message | ||
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)
maxim@phpbeginner.com
www.phpbeginner.com
-----Original Message-----
From: Shane McBride [mailto:php@riversidedesigns.net]
Sent: Friday, April 27, 2001 1:04 AM
To: php-general@lists.php.net
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...