Coding nightmare

rubbersoul

What I need to do is take the 2 txt fileds that you'll see in my form (below) and concat them so that there value will sit in a hidden field which will be uploaded to an SQL database. If anyone can help that would be great. I have provided the sample code....I just need to figure out the concat part (keeping it as a number...NOT as a string) This will end up in mysql as a datetime field. Thanks.

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<title>Untitled Document</title>
</head>

<body>
<form name="form1" method="post" action="">
  <input name="startdate" type="text" id="startdate">
  <input name="starttime" type="text" id="starttime">  

  <input name="totalstart" type="hidden" id="totalstart">
  <br>
  <input name="enddate" type="text" id="enddate">
  <input name="endtime" type="text" id="endtime">  

  <input name="totalend" type="hidden" id="totalend">
  <br>
  <input type="submit" name="Submit" value="Submit">
</form>
</body>
</html>

rubbersoul

startdate and startime have to go from

2004-10-11 08:05:00

to the hidden field starttotal 2004-10-11 08:05:00

enddate and endtime have to go from

2004-10-11 08:05:00

to the hidden field endtotal 2004-10-11 08:05:00

devinemke

there is no point/need to use hidden form elements:

<?
if (!isset($_POST['submit']))
{
	echo '
	<form  action="" method="POST">
	start date: <input type="text" name="startdate"><br>
	start time:<input type="text" name="starttime"><br>
	end date: <input type="text" name="enddate"><br> 
	end time: <input type="text" name="endtime"><br>
	<input type="submit" name="submit" value="submit">
	</form>
	';
}
else
{
	mysql_connect('host', 'username', 'password');
	mysql_select_db('database');

$result = mysql_query("INSERT INTO table SET 
startdatetime = '" . $_POST['startdate'] . ' ' . $_POST['starttime'] . "', 
enddatetime = '" . $_POST['enddate'] . ' ' . $_POST['endtime'] . "'
");
if ($result) {echo 'INSERT OK';}
else {echo mysql_error();}
}
?>