Good advice! Thanks!
Jeff
> -Original Message-
> From: Chris Shiflett [mailto:[EMAIL PROTECTED]
> Sent: Friday, October 03, 2003 5:19 PM
> To: Jeff McKeon; php
> Subject: RE: [PHP] User Authentication Continued
>
>
> > --- Jeff McKeon <[EMAIL P
> --- Jeff McKeon <[EMAIL PROTECTED]> wrote:
> > $query="SELECT * from tickets where VesselID='$_GET['vesselid']'
> > order by Status DESC, Created ASC";
>
> $query = "select * from tickets where vesselid = '{$_GET['vesselid']}'
> order by status desc, created asc";
>
> Note the curly b
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 Authen
* Thus wrote Jeff McKeon ([EMAIL PROTECTED]):
> 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]
>
>
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]
>
--- Jeff McKeon <[EMAIL PROTECTED]> wrote:
> $query="SELECT * from tickets where VesselID='$_GET['vesselid']'
> order by Status DESC, Created ASC";
$query = "select * from tickets where vesselid = '{$_GET['vesselid']}'
order by status desc, created asc";
Note the curly braces.
Hope tha
e VesselID='$_GET['vesselid']' order
by Status DESC, Created ASC";
[code end]
Jeff
> -Original Message-
> From: Chris Shiflett [mailto:[EMAIL PROTECTED]
> Sent: Friday, October 03, 2003 3:45 PM
> To: Jeff McKeon; php
> Subject: Re: [PHP] User Authentica
--- Jeff McKeon <[EMAIL PROTECTED]> wrote:
> The problem I'm having is with the $_GET variables. I guess I'm not
> declaring them correctly. Do I need to set them as soon as the page
> loads, and outside of any functions like so..
>
> [code start]
> $custid = $_GET['custid'];
> $custname = $_GET['
I guess you would either need to make the vars global or else keep
redeclaring them. Obviously, redeclaring them in each function
$var=$_GET["whatever"] is technically the more secure method.
Kris
Jeff McKeon wrote:
Ok,
I've got the user authentication thing down and now I'm continuing to
bu
Ok,
I've got the user authentication thing down and now I'm continuing to
build my trouble ticket tracking system.
So from a "customer profile" page there is a link to "Open Ticket" which
brings up a page to open a trouble ticket.
[html code]
HREF=./open_ticket.php?custid=$custid&custname=$cus
10 matches
Mail list logo
