Re: [InHouse] URL parameter filters with where clauses
Hi,
If you already have a value in the 'where' option, whatever you put in the URL will be appended to that where clause.
One thing you could do is to check to see if there is a value for "type" in the URL. If there is, don't set a where clause.
For example:
$where = "";
if (!@$_REQUEST['type']) {
$where = "put your where clause here";
}
You can then use $where in your where clause. If there's a value of type in the URL, $where will be blank, so just the automatic searching will occur.
Hope this helps
---------------------------------------------------
Jason Sauchuk - Project Manager
interactivetools.com
Hire me! Save time by getting our experts to help with your project.
http://www.interactivetools.com/consulting/