Help Adding Another "where" Clause

[adman4054]

Looking for a little help, in addition to -- where display = 1 and approved = 1, I want to add another -- If the expires date is today or any date in the future I want to show the item.

 

 

 

if (count($where) >= 1) {
$where[] = 'display = 1';
$where[] = 'approved = 1';
$where_clause = implode(' AND ', $where);
} else {
$where_clause = ' false';
}
$listings_query = mysql_query("
 SELECT *
 FROM wholesale
 WHERE $where_clause
 ORDER BY showlogo DESC
") or die(mysql_error());

 

 

Thanks in advance!!

[Barand]

the condition you want is

 

$where[] = "expires >= CURDATE()"

[adman4054]

the condition you want is

 

$where[] = "expires >= CURDATE()"

 

Thank You!