How do i trace this php sql error?

[gerrydevis]

I found this error:
Query failed : Unknown column 'admin' in 'where clause'

well in fact, I successfully pass its id which is 'admin' to other page that will be using its value to a certain query.

here's my query:

$strID=$_GET['ID'];"SELECT userid,password,username,email,active FROM user WHERE userid=".$strID;

 

[lwashere]

i dont see admin column in your query or Could it be from somewhere other than that line?

 

[saniya]

hai

I do not know the layout of your database, but in most cases UserID is a number, not the text as 'Admin'. UserID from Admin in most cases 1.