Search just by first letter

[lapo4ka18]

Hi, It is possible to do a search just by first letter or any number. For expample

I want to have something like this

 

Women Fragrance

# A B C D E F G H I

J K L M N O P Q R S

T U V W X Y Z

 

and for men same think.

 

 

Client press on letter A and in a result it should be all fragrances from WOMEN FRAGRANCE section come up wich starts with letter A.

l

Thanks :)

[mattice]

the problem is the search is performed on multiple db fields. So if you search for Anais Anais by punching in "a" you'll get Calvin Klein and Cacharel as well.

You could create a custom search (= db query) that only looks for the first letter on the product_name field and use that instead.

 

Another (non-coding) solution is to create a category called 'By Alphabet' and put A to Z inthere.

Next you copy all your products in the correct category.

You can then just create a link to category 'A' and it will list all A* prods.

 

HTH

Mattice

[burt]

The query would be something like:

 

SELECT * FROM products, products_description WHERE products_name LIKE 'a%'

 

I'd probably set up a whole new page to accept an input parameter...it would be quite easy to do...

 

Get your hands dirty with PHP...do it yourself and then contribute the script...good learning experience