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?

{$UserLogin} same as email?
(1 viewing) (1) Guest
Go to bottomPage: 1
TOPIC: {$UserLogin} same as email?
#35593
{$UserLogin} same as email? 11 Years, 4 Months ago Karma: 0
Hi, is {$UserLogin} the same as email address?

I have a table that contains activity data for users. There are four fields:
- EMAIL
- DATE
- VALUE1
- VALUE2

I would like to let a logged on user see their activity information, so I'd like to create a data table with the following SELECT statement:

SELECT Date, Value1, Value2
FROM `the_table`
WHERE email={$UserLogin}

I tried it but it didn't work, which makes be believe that {$UserLogin} is not the same as the email address.

Thanks for your help and clarification.

George
The administrator has disabled public write access.
 
#35608
Re:{$UserLogin} same as email? 11 Years, 4 Months ago Karma: 748
Hello,

Download and upgrade the module and use {$UserEmail} predefined variable.

Regards,
ARI Soft
The administrator has disabled public write access.
 
#35624
Re:{$UserLogin} same as email? 11 Years, 4 Months ago Karma: 0
Excellent, thank you!
The administrator has disabled public write access.
 
Go to topPage: 1