One more mystery solved..... Thanks one and all!!!!
Jeff > -----Original Message----- > From: Robert Cummings [mailto:[EMAIL PROTECTED] > Sent: Friday, October 03, 2003 4:55 PM > To: Jeff McKeon > Cc: PHP-General; [EMAIL PROTECTED] > Subject: RE: [PHP] User Authentication Continued.... > > > On Fri, 2003-10-03 at 16:44, Jeff McKeon wrote: > > Actually, here's the problem I get with using global variables in a > > mysql_query string.. > > > > [error begin] > > PHP Parse error: parse error, unexpected T_ENCAPSED_AND_WHITESPACE, > > expecting T_STRING or T_VARIABLE or T_NUM_STRING [error end] > > > > [code begin] > > $query="SELECT * from tickets where > VesselID='$_GET['vesselid']' order > > by Status DESC, Created ASC"; [code end] > > The following will work: > > $query= > "SELECT * " > ."FROM tickets " > ."WHERE VesselID='".$_GET['vesselid']."' " > ."ORDER BY Status DESC, Created ASC"; > > Cheers, > Rob. > -- > .------------------------------------------------------------. > | InterJinn Application Framework - http://www.interjinn.com | > :------------------------------------------------------------: > | An application and templating framework for PHP. Boasting | a > | powerful, scalable system for accessing system services | such as > | forms, properties, sessions, and caches. InterJinn | > | also provides an extremely flexible architecture for | > | creating re-usable components quickly and easily. | > `------------------------------------------------------------' > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php