- Posts: 7
- Thank you received: 0
I have a table with 6 users in it all having different ID's and information.
Using the WHERE@user_id, all users information is shown in the grid.
What do I use, or how do I show only the current logged in user his information?
I tried 'WHERE ID=$user_login_id', but I think I also need '$joomla_user =& JFactory::getUser();
$user_login_id = $joomla_user->id;' somewhere at the start of the code?
Thanks
Steve A.
Please Log in or Create an account to join the conversation.
Hi,
It should work if you put
ID=@user_id
in the 'Additional Where Condition' text box. Of course ID's in your table should match Joomla user ID's, and ID should be the name of the column in the table that you want to use.
Please Log in or Create an account to join the conversation.
Worked perfect thank you.
Nice program BTW!
Cheers
Please Log in or Create an account to join the conversation.