|
One table with selection 8 Years, 2 Months 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.
|
|
|
|
Greetz,
Ken
|
|
|
Re:One table with selection 8 Years, 2 Months ago
|
Karma: 760
|
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 |
|
|
|
|
|
|
