Re: [markr] url search & search engine by date range
Hi,
You would have to do a custom WHERE clause. For example, if you set up your URL like this:
listView.php?publishDateMin=2010-08-01&publishDateMax=2011-07-31
You can set up your query like this:
list($articleRecords, $articleMetaData) = getRecords(array(
'tableName' => 'articles',
'where' => "publishDate >= '".mysql_escape(@$_REQUEST['publishDateMin'])."' AND publishDate <= '".mysql_escape(@$_REQUEST['publishDateMax'])."'",
));
Hope this helps get you started
---------------------------------------------------
Jason Sauchuk - Project Manager
interactivetools.com
Hire me! Save time by getting our experts to help with your project.
http://www.interactivetools.com/consulting/