thanks, thats works, and has got me a step closer, but not yet complete.
I have a select box for the search function, with different statuses of progress of reports( compelte, in progress, no action, awaiting information). The user can select these, then enter a search term, and the page should reload with the search results.
The method you gave me above works fine, but if the user doesn't enter anything, i'd like it to retreive all records of that status ie if the textbox is left blank, and "complete" is chosen on the select box, pressing submit will find all records with a status of complete. If the user enters, say, "marketing", and the "in progress" selection is chosen, it will find all records matching the word marketing and with a status of in progress.
the second example works fine, but not the first. How can i implement this with the solution mentioned above?
is there no way to simply call the function from the form ie:
<form name = "searchform" method = "post" action = search()>
?
Thanks for your time
🙂