translate WHERE statement from ASP to PHP

[Guest]

What would be the PHP equivelant to a ASP/SQL recordset query that's filtered with

WHERE expire >= getDate()

getDate() does not work with PHP? I've tried things like WHERE expire >= date('Y-m-d') with no luck. Keep in mind, the expire data is formatted like this: 2007-10-20 00:00:00 in the MySQL database (apache server).

[Newsgroup_User · Accepted solution]

On Sun, 21 Oct 2007 05:19:38 +0000 (UTC), "jsteinmann"
<webforumsuser@macromedia.com> wrote:

>What would be the PHP equivelant to a ASP recordset query that's filtered with
>
> WHERE expire >= getDate()


The MySQL equivalent would be:

WHERE expire >= CURRENT_DATE

Gary