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
ED]> To: <[EMAIL PROTECTED]> Sent: Sunday, March 02, 2003 7:46 AM Subject: [PHP] PHP SQL Code > 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 < > from_unixtime(unix_time

[PHP] PHP SQL Code

2003-03-01 Thread Philip J. Newman
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 < from_unixtime(unix_timestamp(now())-(15760*60)) AND sActive = 'Y' ORDER BY sUpdated DESC"; This don't quite work .. Any suggestions? -- Philip J. Newman

[PHP] php/sql code gives blank page

2001-08-03 Thread sono
I created a little php script to run and display stuff on my browser for printing. When I run the command I get a blank page though. I tested the syntax of my command in mysql and on phpMyAdmin to make sure it worked. Here is the code: -