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?

Use dropdown box instead of search box
(1 viewing) (1) Guest
Go to bottomPage: 1
TOPIC: Use dropdown box instead of search box
#23021
Use dropdown box instead of search box 12 Years, 6 Months ago Karma: 0
Hi there,

Would it be possible, presumably by changing a little of the code, to change the search box functionality to a drop down box (where the values in the drop down matched those in one column of the table).

For example if you had a bunch of records and one of the columns was the year of creation, then the drop down box would have a list of all the years.

Kind regards, domc1
The administrator has disabled public write access.
 
#23024
Re:Use dropdown box instead of search box 12 Years, 6 Months ago Karma: 748
Hello,

Sorry, but the extension doesn't support this ability. It can't be done with a little changing of a code.

Regards,
ARI Soft
The administrator has disabled public write access.
 
#23040
Re:Use dropdown box instead of search box 12 Years, 6 Months ago Karma: 0
Without modding the module, is it possible to feed the table only first names starting with for example the letter a from the sql query ?, that way you could have a different module for each letter of the alphabet, and have the filter on the page itself load the page with that table with that sql query on it ?. A bit of a backwards way of doing it , but saves having to mod the module, not sure if you can filter the mysql results like this ?, its a way round I was considering if it cant be added easily by modding the code ?,.
The administrator has disabled public write access.
 
#23052
Re:Use dropdown box instead of search box 12 Years, 6 Months ago Karma: 748
The extension supports ability to use request variables in a SQL query. For example if a letter is sent with help "search" request variable, a query will look like:

Code:


SELECT
 id,
 title
FROM
 #__content
WHERE 
 title LIKE {$REQUEST:search} + "%"



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