Re: Unexpected T_ENCAPSED...

From: Date: Sat, 24 Jul 2004 19:02:09 +0000
Subject: Re: Unexpected T_ENCAPSED...
References: 1  Groups: php.general 
Request: Send a blank email to php-general+get-191760@lists.php.net to get a copy of this message
Harlequin 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'
because your query looks like: SELECT * FROM RegisteredMembers WHERE UserID = Admin you miss quotes around $UserID: $CaptureDetails = "SELECT * FROM RegisteredMembers WHERE UserID = '$UserID'";

« previous php.general (#191760) next »