Trouble with time in a form.. inserting into database..
Posted: Sat Jun 29, 2002 6:16 am
I'm having three select boxes... 0-12, 0-59, AM (1)/PM(2). Then if it's PM I add 12.. the time isn't showing up correctly when I display or open it back to edit. Anyone have a better way to do this? I'm stuck.
$num_rows = mysql_num_rows($result);
if ($num_rows > 0) {
echo "Event already exists.<br>\n";
echo "<br><a href=\"javascript:history.go(-1)\">Go back</a><br>\n";
} else {
if ($HTTP_POST_VARS['opentimeampm'] == 2)
$HTTP_POST_VARS['opentimehour'] += $HTTP_POST_VARS['opentimehour'] + 12;
$opentime = $HTTP_POST_VARS['opentimehour'].":".$HTTP_POST_VARS['opentimemin'].":00";
if ($HTTP_POST_VARS['closetimeampm'] == 2)
$HTTP_POST_VARS['closetimehour'] += 12;
$closetime = $HTTP_POST_VARS['closetimehour'].":".$HTTP_POST_VARS['closetimemin'].":00";
$datemodified = date("Y-m-d H:i:s");
$query = "INSERT INTO event_events VALUES ('','$HTTP_POST_VARS[title]','$HTTP_POST_VARS[headliner]','$HTTP_POST_VARS[talent]','$HTTP_POST_VARS[description]','$HTTP_POST_VARS[date]','$HTTP_POST_VARS[url]','$HTTP_POST_VARS[url_tickets]','$HTTP_POST_VARS[email]','$HTTP_POST_VARS[price]','$HTTP_POST_VARS[info_lines]','$opentime','$closetime','$HTTP_POST_VARS[venue_capacity]','$HTTP_POST_VARS[venue_name]','$HTTP_POST_VARS[venue_address]','$HTTP_POST_VARS[venue_city]','$HTTP_POST_VARS[venue_state]','$HTTP_POST_VARS[venue_zip]','$HTTP_POST_VARS[age]','$datemodified','$HTTP_POST_VARS[id]','$HTTP_POST_VARS[catid]','$HTTP_POST_VARS[regionid]')";
$result = mysql_query($query, $link);
echo("Event added.<br>\n");
echo("<br><a href=\"promoter.php\">Back to promoter index</a><br>\n");
$num_rows = mysql_num_rows($result);
if ($num_rows > 0) {
echo "Event already exists.<br>\n";
echo "<br><a href=\"javascript:history.go(-1)\">Go back</a><br>\n";
} else {
if ($HTTP_POST_VARS['opentimeampm'] == 2)
$HTTP_POST_VARS['opentimehour'] += $HTTP_POST_VARS['opentimehour'] + 12;
$opentime = $HTTP_POST_VARS['opentimehour'].":".$HTTP_POST_VARS['opentimemin'].":00";
if ($HTTP_POST_VARS['closetimeampm'] == 2)
$HTTP_POST_VARS['closetimehour'] += 12;
$closetime = $HTTP_POST_VARS['closetimehour'].":".$HTTP_POST_VARS['closetimemin'].":00";
$datemodified = date("Y-m-d H:i:s");
$query = "INSERT INTO event_events VALUES ('','$HTTP_POST_VARS[title]','$HTTP_POST_VARS[headliner]','$HTTP_POST_VARS[talent]','$HTTP_POST_VARS[description]','$HTTP_POST_VARS[date]','$HTTP_POST_VARS[url]','$HTTP_POST_VARS[url_tickets]','$HTTP_POST_VARS[email]','$HTTP_POST_VARS[price]','$HTTP_POST_VARS[info_lines]','$opentime','$closetime','$HTTP_POST_VARS[venue_capacity]','$HTTP_POST_VARS[venue_name]','$HTTP_POST_VARS[venue_address]','$HTTP_POST_VARS[venue_city]','$HTTP_POST_VARS[venue_state]','$HTTP_POST_VARS[venue_zip]','$HTTP_POST_VARS[age]','$datemodified','$HTTP_POST_VARS[id]','$HTTP_POST_VARS[catid]','$HTTP_POST_VARS[regionid]')";
$result = mysql_query($query, $link);
echo("Event added.<br>\n");
echo("<br><a href=\"promoter.php\">Back to promoter index</a><br>\n");