Multiple variable search, some empty
Posted 14 June 2006 - 03:32 PM
WHERE gender = 'colname' AND genre LIKE '%colgenre%' AND voicetype LIKE '%colvoice'
ORDER BY name ASC
Also, I am using drop-down lists at the moment. How can I set up the search to use multiple checkboxes for 'genre' and search for ANY of the selected - e.g. if you tick 'documentary' and 'corporate' it will look for both of those values in the 'genre' column, as well as the other variables.
Hope you can help. I am new to database driven sites and this project has snowballed!
Posted 14 June 2006 - 05:05 PM
Posted 14 June 2006 - 06:57 PM
Does the extensiion work for only searches where you type in the variables? Or can it be configured for drop-down menus / checkboxes?
Is there a way to do this without shelling out for an extenstion?
Posted 15 June 2006 - 01:46 AM
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users