Time comparison

From: Date: Sun, 31 Dec 2000 04:36:51 +0000
Subject: Time comparison
References: 1  Groups: php.db 
Request: Send a blank email to php-db+get-5538@lists.php.net to get a copy of this message
Hi guys-- Sorry to bother you with what is probably a simple question. I've read through the manual and I'm still not sure of what I'm doing; I'm getting caught in strings vs. numbers, ie, I'm afraid that what I'm trying to do won't work because I'm dealing with strings instead of numbers. I'm trying to pull rows out of a MySQL table where the date stamp looks like: 2000-12-30 19:22:00 I want to pull all rows that have been placed in the db in the last 24 hours. How can I compare the current date/time to the date stamps in the table? Thanks, Lynn -- Lynn Siprelle, Siprelle & Associates: Web Construction and Publishing Chief Assoc. Josephine b. 9/9/97 * New Assoc. Louisa due 5/1/01 Business: lynn@siprelle com | Personal: lynsa@siprelle.com The New Homemaker: http://www.newhomemaker.com/

« previous php.db (#5538) next »