CC Zona [[EMAIL PROTECTED]] wrote:
> 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
^^^^^^^^^
Just a technicality, but I think I remember this to be
mysql_errno(). But CC is right - in your "die", give yourself
as much info about the error as possible.
--
Hardy Merrill
Mission Critical Linux, Inc.
http://www.missioncriticallinux.com
> 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]
--
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]
