|
|
Sometimes you need to present different data to different groups
of users. Let's say you run a classified ads board and needs to
display last seven days data to regular users while admin should be
able to see all adds.
For this purpose use Before
SQL Query event of the List page.
 Note: Change
the values listed in red to
match your specific needs.
1. For MS SQL Server database:
|
if ($_SESSION["UserID"]!="admin")
$strWhereClause = whereAdd($strWhereClause, "DATEDIFF(day,GETDATE(),
DateColumn) <= 7");
|
2. For MySQL database:
|
if ($_SESSION["UserID"]!="admin")
$strWhereClause = whereAdd($strWhereClause, "DATE_SUB(CURDATE(),
INTERVAL 7 DAY) <= DateColumn");
|
3. For MS Access database:
|
if ($_SESSION["UserID"]!="admin")
$strWhereClause = whereAdd($strWhereClause, "DATEDIFF('d',Now(),
DateColumn) <= 7");
|
whereAdd() function adds
new AND condition to
WHERE clause. More
info on Data Access Layer functions.
|
