My search is not working. It returns all results.
URL in PM, page attached.
URL in PM, page attached.
In your Recordset SQL statement you have:
WHERE p.enddate >= CURDATE() OR p.eventdate IS NULL ORDER BY
The OR in there is overriding any other filters you put on it. You have to use:
WHERE (p.enddate >= CURDATE() OR p.eventdate IS NULL) ORDER BY
That way it is kept separate from other filters added by your database search server behavior.
Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.
These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.