I'm using the following code to insert date into my
mySQL table named "Booking". I've created variables
that store the date with dashes "-" seperating them.
But it's not working. It's giving me an error on the
$SQl line.
following is the code :
<?php
$db = mysql_connect("localhost","root");
mysql_select_db("motorola",$db);
$realsdate="$syear"."-"."$smonth"."-"."$stdate";
$realedate="$eyear"."-"."$emonth"."-"."$endate";
$realstime="$shh".":"."$smm"."-"."$sttime";
$realetime="$ehh".":"."$emm"."-"."$entime";
$sql = INSERT INTO booking
(room,sdate,edate,stime,etime,purpose,reserved) VALUES
('$rooms','$realsdate','$realedate','$realstime','$realetime','$purpose','$res');
$result = mysql_query($sql) or Die ("An unexpected
error occured. Please go back and book again.");
?>
??
Cheers,
T. Edison jr.
=====
Rahul S. Johari (Director)
******************************************
Abraxas Technologies Inc.
Homepage : http://www.abraxastech.com
Email : [EMAIL PROTECTED]
Tel : 91-4546512/4522124
*******************************************
__________________________________________________
Do You Yahoo!?
Get email at your own domain with Yahoo! Mail.
http://personal.mail.yahoo.com/
--
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]
