MySQL error: Unknown column … in 'where clause'

[ACBMSE]

I'm a newbie, can you please help?

I'm getting a mysql error "Unknown column 'E0000001' in 'where clause'"

The id is in the URL: ...user-profile.php?id=E0000001

My Query

$query = mysqli_query($con, "SELECT * FROM UserList WHERE UserID=".$id) or die (mysqli_error($con));

Thank you

Edited September 18, 2019 by ACBMSE

[gw1500se]

There is no column named "UserID" in the table named "UserLIst".

[ACBMSE]

Here is an image of the table. UserID is a column.

[Barand]

16 minutes ago, ACBMSE said:

SELECT * FROM UserList WHERE UserID=".$id)

.. therefore the query being executed is

SELECT * FROM UserList WHERE UserID=E0000001

1 ) String variables in a SQL statement need to be in single quotes otherwise they are thought to be a column name.

2 ) The variable shouldn't be there at all - you should be using a prepared statement and passing the id as a parameter

$query = mysqli_prepare($con, "SELECT * FROM UserList WHERE UserID = ? ");
$query->bind_param('s', $id);
$query->execute();