RE: [PHP] User Authentication Continued....
| From: | Jeff McKeon | Date: | Fri, 03 Oct 2003 20:57:10 +0000 |
| Subject: | RE: [PHP] User Authentication Continued.... | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-164986@lists.php.net to get a copy of this message | ||
One more mystery solved.....
Thanks one and all!!!!
Jeff
> -----Original Message-----
> From: Robert Cummings [mailto:robert@interjinn.com]
> Sent: Friday, October 03, 2003 4:55 PM
> To: Jeff McKeon
> Cc: PHP-General; shiflett@php.net
> 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
>
>