This topic is locked

Default strWhereClause

9/24/2009 6:56:53 PM
PHPRunner General questions
N
nickditrolio author

Hi, I would like to use a default Where clause in a SQL statement in my list page. If it's the first time the user enters the page, I'd like to modify the Where part of the SQL. This is what I have, but it's doesn't work because it doesn't recognize the _request variable:
global $conn;

if(@$_Request["a"]=="search"&& @!$_Request["searchfor"])

{$strWhereClause=WhereAdd($strWhereClause,"week=2009-09-20");

}
Thanks.

J
Jane 9/25/2009

Nick,
please see my changes below:

global $conn;

if(@$_REQUEST["a"]!="search"&& @!$_REQUEST["SearchFor"])

{

$strWhereClause=WhereAdd($strWhereClause,"week=2009-09-20");

}