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?

{$UserLogin} same as email?
(1 viewing) (1) Guest
Go to bottomPage: 1
TOPIC: {$UserLogin} same as email?
#35593
{$UserLogin} same as email? 11 Years, 10 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, 10 Months ago Karma: 760
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, 10 Months ago Karma: 0
Excellent, thank you!
The administrator has disabled public write access.
 
Go to topPage: 1