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'";
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
