Skip to main content
A
Anonymous
October 21, 2007
Answered

translate WHERE statement from ASP to PHP

  • October 21, 2007
  • 1 reply
  • 190 views
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).
This topic has been closed for replies.
Correct answer Newsgroup_User
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

1 reply

N
Newsgroup_UserCorrect answer
Inspiring
October 21, 2007
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
Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices