Home News Contact Us Forum About Us Demos Products F.A.Q.
Shopping Cart
You currently have 0 items in your cart.


Recent Events
  • 31/12/2023 New Year SALE

    We are glad to announce New Year SALE. 25% discount for all our extensions. Use NY24 coupon code. Hurry up the discount is valid till 7 January.

  • 21/11/2023 BLACK FRIDAY 23 is coming

    BIG SALE, 35% discount for all our extensions. Use BF23 coupon code. Hurry up the discount is valid till 27 November.


2Checkout.com, Inc. is an authorized retailer of goods and services provided by ARI Soft. 2CheckOut




Follow us on twitter



Welcome, Guest
Please Login or Register.    Lost Password?

LOGGED IN USERS FILTERING
(1 viewing) (1) Guest
Go to bottomPage: 1
TOPIC: LOGGED IN USERS FILTERING
#24822
LOGGED IN USERS FILTERING 12 Years, 2 Months ago Karma: 0
Hi All,

I am new to this module, could anyone provide an information on how to filter a query based on the logged in users?

Thanks so much
arm
User Offline Click here to see the profile of this user
The administrator has disabled public write access.
 
#24828
Re:LOGGED IN USERS FILTERING 12 Years, 2 Months ago Karma: 748
Hello,

It is possible to use {$UserId} predefined variable in a SQL query. An example SQL query:

Code:


SELECT
 *
FROM
 #__users
WHERE
 id = {$UserId}



Regards,
ARI Soft
The administrator has disabled public write access.
 
Go to topPage: 1