RE: [PHP] PHP SQL Code

2003-03-02 Thread John W. Holmes
> > > I would like yo show the users in a list that have a date that is more > > > than > > > 60 days old. > > > > $sql = "SELECT * FROM stompers WHERE sUpdated < CUR_DATE() - INTERVAL 60 > > DAY AND sActive = 'Y' ORDER BY sUpdated DESC"; > > This one returns a 'Could not get Query' warning ... so

Re: [PHP] PHP SQL Code

2003-03-02 Thread Philip J. Newman
This one returns a 'Could not get Query' warning ... so thats out. - Original Message - From: "John W. Holmes" <[EMAIL PROTECTED]> To: "'Philip J. Newman'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Monday, March 03, 2003 5:3

RE: [PHP] PHP SQL Code

2003-03-02 Thread John W. Holmes
> I would like yo show the users in a list that have a date that is more > than > 60 days old. $sql = "SELECT * FROM stompers WHERE sUpdated < CUR_DATE() - INTERVAL 60 DAY AND sActive = 'Y' ORDER BY sUpdated DESC"; ---John W. Holmes... PHP Architect - A monthly magazine for PHP Professionals. Ge

Re: [PHP] PHP SQL Code

2003-03-02 Thread Tim Ward
I'd use ... WHERE UNIX_TIMESTAMP(NOW()) - UNIX_TIMESTAMP(sUpdated) > 60*60*24*60 but I'm sure someone will come up with something more efficient. Tim Ward http://www.chessish.com mailto:[EMAIL PROTECTED] - Original Message - From: Philip J. Newman <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED