Hi,
I need to filter my history table with the joomla userid which is currently logged in and have tried various configurations but not getting any data displayed. My sql statement is:
SELECT *
FROM `history`
WHERE `clientid` = '$UserId'

I'm expecting this to display ALL the rows of data where the history table clientid = the logged in user.

If I hardcode the sql to my id, then I can see all my data, but can't get the variable $UserID to filter anything
please help

Hello,

Use the next SQL query:



Regards,
ARI Soft

Thanks, but I did try that and still get "no data available" so this does not seem to help
My DB type is set to Joomla! DB, and although I get all my history information when I put clientID = Ant101 (my username) the history table is infact not part of the jooml! Db but is a table on the localhost on a different DB, but it seems to query it just fine when retrieving all the history data. I can't confirm if the $userID is actually being queried correctly to the joomla db ? It seems this is when the problem is?

{$UserId} parameter contains a user ID (it is an integer value). If you want to use login, use {$UserLogin} predefined variable. Query will look like:



Regards,
ARI Soft

Fantastic, thank you very much this works correctly now !