Re: Unexpected T_ENCAPSED...
| From: | Jason Davidson | Date: | Sat, 24 Jul 2004 19:04:41 +0000 |
| Subject: | Re: Unexpected T_ENCAPSED... | ||
| References: | 1 2 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-191762@lists.php.net to get a copy of this message | ||
Sorry, let me clearify.. unless UserId is an integer, quote it !!
jason
On Sat, 24 Jul 2004 12:03:54 -0700, Jason Davidson
<jason.davidson@gmail.com> wrote:
> whats in UserId var.. any spaces or nonword chars.. if so, quote it.
>
> Jason
>
>
>
> On Sat, 24 Jul 2004 19:49:04 +0100, Harlequin
> <michael.mason@arraspeople.co.uk> wrote:
> > I've been working on a query to retrieve a user's data based on their UserID
> > that is stored in a variable "$_SESSION['logname']" which underneath I
> > convert using: $UserID = $_SESSION['logname'];
> >
> > But when I execute a SELECT query:
> >
> > $CaptureDetails = "SELECT * FROM RegisteredMembers
> > WHERE UserID = $UserID";
> >
> > I get:
> >
> > Unknown column 'Admin' in 'where clause'
> >
> > I've tried everything I can think of. any suggestions...?
> >
> > --
> > -----------------------------
> > Michael Mason
> > Arras People
> > www.arraspeople.co.uk
> > -----------------------------
> >
> > --
> > PHP General Mailing List (http://www.php.net/)
> > To unsubscribe, visit: http://www.php.net/unsub.php
> >
> >
>