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


Recent Events
  • 05/09/2017 BIG Autumn SALE

    Use AUTUMN17 coupon code to buy our WordPress or Joomla! extensions with 25% discount. Hurry up! The offer is valid till 11 September.

  • 14/04/2017 Happy Easter

    Wish a Happy Easter and give 30% discount for all our WordPress and Joomla! extensions. Use EASTER17 coupon code. The offer is valid till 17 April.


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?

One table with selection
(1 viewing) (1) Guest
Go to bottomPage: 1
TOPIC: One table with selection
#58390
One table with selection 1 Year, 1 Month ago Karma: 0
Hi all,

I have one big table with data.
I made different modules to show the data from that table with

SELECT Code,State,Name,2M,6M,10M,12M,15M,17M,20M,30M,40M,80M
FROM `WA_TBL` WHERE DXCCID=227 ORDER BY State

In every module the DXCCID is different.

Is there a way that i can use a pulldown selection to select the different DXCCID's.
So i need only one module.
The administrator has disabled public write access.
Greetz,

Ken
 
#58394
Re:One table with selection 1 Year, 1 Month ago Karma: 666
Hello,

It is possible to use request variables in "WHERE" clause of SQL query. For example if want to use "id" request variable, a query will look like:

Code:


SELECT 
 Code,State,Name,2M,6M,10M,12M,15M,17M,20M,30M,40M,80M
FROM 
 `WA_TBL` 
WHERE 
 ({$REQUEST:id|empty:''} = '' || DXCCID={$REQUEST:id|empty:''}) 
ORDER BY State



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