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
