In article <[EMAIL PROTECTED]>,
[EMAIL PROTECTED] ("Thomas Edison Jr.") wrote:
> 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.");
> ?>
Your value for the variable "sql" isn't enclosed in quotes. BTW, tracking
down problems with a sql query gets easier when you give yourself a more
informative die() message, such as:
or die ("MySQL says: " . mysql_errorno() . " " . mysql_error() . "\nPHP
says: $errormsg");
--
CC
--
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]
