Re: [PHP] Query Returning Error

2004-10-13 Thread Jason Wong
On Wednesday 13 October 2004 15:32, Harlequin wrote: this is such a basic question I'm embarrassed to ask but the query worked fine a few minutes ago and now returns an error: Change everything back to what it was a few minutes ago? -- Jason Wong - Gremlins Associates - www.gremlins.biz Open

Re: [PHP] Query Returning Error

2004-10-13 Thread Harlequin
Doh...! thanks mate. -- - Michael Mason Arras People www.arraspeople.co.uk - Jason Wong [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] On Wednesday 13 October 2004 15:32, Harlequin wrote: this is such a basic question I'm

Re: [PHP] Query Returning Error

2004-10-13 Thread Jason Davidson
should Query01 have a $ in front of it, i assume its a var Jason Harlequin [EMAIL PROTECTED] wrote: Morning all. this is such a basic question I'm embarrassed to ask but the query worked fine a few minutes ago and now returns an error: I get an error: Parse error: parse error,

Re: [PHP] Query Returning Error

2004-10-13 Thread Jordi Canals
On Wed, 13 Oct 2004 08:32:17 +0100, Harlequin [EMAIL PROTECTED] wrote: Morning all. this is such a basic question I'm embarrassed to ask but the query worked fine a few minutes ago and now returns an error: I get an error: Parse error: parse error, unexpected '=' in sample.php on line 2

RE: [PHP] Query Returning Error

2004-10-13 Thread Graham Cossey
Besides adding $ to Query01, I have had little luck in the past when using $_POST or $_GET directly in an evaluated string. If you are still having problems, try something like: ?php $user = $_POST['TXT_UserID']; $pwd = $_POST['TXT_UserPassword']; // Authenticate User: $Query01 = SELECT *

Re: [PHP] Query Returning Error

2004-10-13 Thread Chris Dowell
You can get around this problem more easily by putting your variables inside curly brackets when they appear inside strings. See here: http://uk.php.net/manual/en/language.types.string.php#language.types.string.parsing.complex Or as an example: ?php $Query01 = SELECT * FROM Users WHERE UserID

RE: [PHP] Query Returning Error

2004-10-13 Thread Graham Cossey
Thanks Chris, that'll help keep my code a bit more 'compact'. (Sorry Harlequin, kinda hijacked your post here) Graham -Original Message- From: Chris Dowell [mailto:[EMAIL PROTECTED] Sent: 13 October 2004 11:57 To: [EMAIL PROTECTED] Subject: Re: [PHP] Query Returning Error You can

RE: [PHP] Query Returning Error

2004-10-13 Thread Ford, Mike
To view the terms under which this email is distributed, please go to http://disclaimer.leedsmet.ac.uk/email.htm -Original Message- From: Chris Dowell [mailto:[EMAIL PROTECTED] Sent: 13 October 2004 11:57 Note also that you didn't quote the index you were using inside the