global variable

[Martin Williams]

Hello, Im a newbie,
Im haveing an issue with a query, Here is my exacty syntax

select * from db where user_login = %current_user_id%

and this isnt working.

I was told
"if you would like to user current user's ID in the query (eg, to show records

from some table only for the currnt user) you can use the placeholder

%CURRENT_USER_ID% it will be replaced with the actual ID value of the

currently logged in user at runtime moment.

so, select * from db where user_login = %CURRENT_USER_ID% will be sent as

select * from db where user_login = 1
(if current user has an id of 1)"

but its not working

Im using phpmyadmin and running the syntax in there

Please help,,