ARI Soft - [SOLVED] Using a drop down list to change WHERE

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

[SOLVED] Using a drop down list to change WHERE

(1 viewing) (1) Guest

Page: 1

TOPIC: [SOLVED] Using a drop down list to change WHERE

Forum Tools

#30069

[SOLVED] Using a drop down list to change WHERE 12 Years, 4 Months ago

Karma: 2

So I need to change my SQL query based on the user's choice in a drop down list.

The list will contain dates.

The query changes based on the date:

SELECT * FROM table WHERE Date={date} ORDER BY f1 DESC, f2 DESC;

So if the user select 2012-Jan-01 from the drop down list, the URL changes to:

www.domain.com/page.php?date=2012-Jan-01

I've read some posts about {$REQUEST}, but I'm having no luck.

Does anyone have help on this approach?

JugglingReferee

Last Edit: 2012/07/26 03:44 By JugglingReferee.

The administrator has disabled public write access.

#30070

[SOLVED] Using a drop down list to change WHERE 12 Years, 4 Months ago Karma: 2

After MANY test queries, trials with fake data, etc, I have the solution:

Code:

SELECT @curRank := @curRank +1 AS Rank, Table1.Name, Table2.TieBreakingField1, Table2.TieBreakingField2, Table2.TieBreakingField3, Table2.TieBreakingField4, Table2.TieBreakingField5

FROM Table1, Table2, (

SELECT @curRank :=0

) r

WHERE Table1.FieldID=Table2.FieldID

AND Table1.LookUpField={$REQUEST:$LookUpField}

ORDER BY TieBreakingField1 DESC, TieBreakingField2 DESC, TieBreakingField3 DESC, TieBreakingField4 DESC, TieBreakingField5;

As you can see, I also have the RANK column as researched in my previous topic.