ARI Soft - sql query for current loged in user data only

Home

News

Forum

About Us

Demos

Products

F.A.Q.

Featured Demos

ARI Smart Content demo

ARI Quiz demo

WordPress Quiz plugin

WordPress Lightbox plugin

e-mail: info@ari-soft.com

Shopping Cart

You currently have 0 items in your cart.

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

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

more...

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

Welcome, Guest
Please Login or Register. Lost Password?

ARI Soft Forum

Joomla components

ARI Data Tables

sql query for current loged in user data only

(1 viewing) (1) Guest

Page: 1

TOPIC: sql query for current loged in user data only

Forum Tools

#38709

sql query for current loged in user data only 11 Years, 8 Months ago Karma: 0

please help, i need to retrieve data that related to current user only.
please help me with the query to use. i used this code below but nothing shows up on the table.

Code:

SELECT email, name FROM o7va4_users WHERE name = {$_SESSION['username']}

moivan

The administrator has disabled public write access.

#38752

Re:sql query for current loged in user data only 11 Years, 8 Months ago Karma: 5

you can try using

Code:

SELECT id,email, name FROM o7va4_users WHERE id = {$UserId}

if 'o7va4_users' is not your default jml_user table you can JOIN your current table with a common column entry (eg: name or id) to the jml_user table

trevor

trevor_stp

Last Edit: 2013/03/21 23:44 By trevor_stp.

The administrator has disabled public write access.

#46689

Re:sql query for current loged in user data only 10 Years, 11 Months ago	Karma: 0
Hi, This is the same sort of query I need but could not get it to work with SQL table. Does anyone have any other ideas on how to use the current logged in users details in the query? I have tried: WHERE id = {$UserId} But it does not display any results, does the syntax need to be different? Thanks

ianliv

The administrator has disabled public write access.

#46690

Re:sql query for current loged in user data only 10 Years, 11 Months ago	Karma: 760
It works for "ARI Data Tables" extension, not for "ARI Smart Content". Regards, ARI Soft

admin

The administrator has disabled public write access.

Page: 1

Useful Links