writing a time to mysql????
| From: | Shane McBride | Date: | Thu, 26 Apr 2001 16:04:05 +0000 |
| Subject: | writing a time to mysql???? | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-50472@lists.php.net to get a copy of this message | ||
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...