https://antibiotiqueaugmentin.com/surdosage-augmentin-bebe/
× This is the optional Forum header for the Suggestion Box.

User id issue

  • Idunnit1
  • Idunnit1's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
14 years 3 months ago #152

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.

  • Idunnit1
  • Idunnit1's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
14 years 3 months ago #153

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 :cheer:

Please Log in or Create an account to join the conversation.

More
14 years 3 months ago #155

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.

Moderators: tomaz
Time to create page: 0.169 seconds

Contact Us

Contact us on Discord

Contact us on Facebook