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


Recent Events
  • 23/11/2024 Black Friday 2024

    BIG SALE, 30% discount for all our extensions. Use BF24 coupon code. Hurry up the discount is valid till 3 December.

  • 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.


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?

create table by userid
(1 viewing) (1) Guest
Go to bottomPage: 1
TOPIC: create table by userid
#7438
create table by userid 14 Years, 2 Months ago Karma: 0
hi i need to create a table showing only the current users records from a table
is there a way i can do this...
The administrator has disabled public write access.
 
#7439
Re:create table by userid 14 Years, 2 Months ago Karma: 760
Hello,

{$UserId} predefined variable can be used in SQL query. It will be replaced with ID of currently logged user. For example you can use the following SQL query:

Code:


SELECT `name`,`username`,`email` FROM #__users WHERE id = {$UserId}



Regards,
ARI Soft
The administrator has disabled public write access.
 
#7441
Re:create table by userid 14 Years, 2 Months ago Karma: 0
thank you - worked like a charm

i must have had a syntax issue cos that was what i was trying to use

all good now!
The administrator has disabled public write access.
 
Go to topPage: 1