PHP SQL Code
| From: | Philip J. Newman | Date: | Sun, 02 Mar 2003 07:46:48 +0000 |
| Subject: | PHP SQL Code | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-137766@lists.php.net to get a copy of this message | ||
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.
Head Developer
info@philipnz.com
+64 (9) 576 9491
+64 021-048-3999
------
Friends are like stars
You can't allways see them,
but they are always there.
------
Websites:
PhilipNZ.com - Design.
http://www.philipnz.com/
info@philipnz.com
Philip's Domain // Internet Project.
http://www.philipsdomain.com/
newmanpj@philipnz.com
Vital Kiwi / NEWMAN.NET.NZ.
http://www.newman.net.nz/
philip@newman.net.nz