product search

[geordie728]

I've developed a product search facility and was wondering if I could capture the searchquery into a searchquery table.

At first I thought I could add an insert record when update is pressed but then remembered that the search has a GET action.

Has anyone tried something similar or know if this is possible and what I can do to achieve.

[geordie728]

ok made some very good progress with this, I've got the form searching and inserting a record to update a searchquery table.

the data going into the table though isn't just the keywords the user is searching, it's basically submitting the whole query into the database.

I tried to get it to take the input from my search field but that is returning null unfortunately.

I should have added that it needs to be just the keywords searched for by the user because I want to pull these into my footer using a recordset so that customers can see what other customers have searched on. Similar idea to a tag cloud.

[geordie728]

now sorted this. Exposing the header search form, I was able to insert a record using the data from it.

All rosy and a nice collection of search terms now :D