Hi All,
I am in the process of creating a site that uses a database of products but I am having difficulty in creating a product search interface for the users which is rendering my site useless, as its difficult to find the products you want. I have been searching for tutorials or posts on anything related but have been unable to find anything, hence this post. I am aiming for a category, brand price search functionality not too disimilar to the Kelkoo setup. I have a simple text box search working but want to give the user the ability to refine the results further. Any advice or help is much appreciated!

Cheers.

Hi,

Don't suppose anyone has any information for me....quite a few views so far so still hopeful of a decent response or two!!

maybe if this was in whatever server side code forum your site uses, otherwise this is just a generic question

Hi,
Sorry about the wait in me responding, I have been persisting and have made a little head way but help and suggestions still needed. I am currently doing it in PHP.

Cheers

The question is too general. Problem need more information about.

For starter, I will say:
1. you need to have a form something like:
<form action="/search.php">
Query: <input type="edit" name="q"/>
<input type="submit" value="Search"/>
</form>
2. Then in your php script (search.php), you need to convert q to a SQL statement. For example:
"select * from products where description like '%".$_REQUEST['q']."%'";
3. then display the result one by one.
4. then you also need to have an "advance search UI" like advance_search.php which will take more fields (for example, if your production database is about clothing, you need to let the user specify color, size, etc..). Then do step 2 again.

Again, the solution is very general, you probably need to do more than this (for example, make sure the query is MySQL safe, etc..)

It's true - you shouldn't be posting a question and waiting forever for it to be answered - you should be looking up php scripts on google, writing the script you want (or otherwise buying marketplace credits, and paying me a few quid to do it for you - or someone else - because hey, it's a job a lot of people here do for money not kicks!)

or maybe even post in the PHP Forum where the thread will be in about 5 seconds