- Posts: 2
- Thank you received: 0
Hi,
I am having a problem with the 'id' = '@user_id' command. What I want is the person that is logged in to only see the data from a table that has there id on it. If I remove the command then the person can see all the data from the table. When the command is in the where box then the logged in person gets a message "no records found". I am probably doing something stupid as I am new to this.
any help will be welcome.
Please Log in or Create an account to join the conversation.
The solution has now been found.
I have found the fix through e-mail which was very quick.
The solution for my problem was to add uid=@user_id in the WHERE box instead of 'id' = '@user_id'.
Thanks again for the help
Please Log in or Create an account to join the conversation.
You could also write id = '@user_id' or `id` = 'user_id'. Note that there is a difference between ` and '.
Please Log in or Create an account to join the conversation.