SELECT UNIX_TIMESTAMP(NOW()) - UNIX_TIMESTAMP(your_column) / 60 AS
Minutes FROM your_table
---John Holmes...
-Original Message-
From: Leif K-Brooks [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 26, 2002 12:29 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Caculating minutes
Thanks a lot for your help, but just a not to anuyone else who tries
this. Since there's no ()s around
UNIX_TIMESTAMP(NOW()) - UNIX_TIMESTAMP(your_column)
, it thinks that you're trying to get:
UNIX_TIMESTAMP(NOW()) - (UNIX_TIMESTAMP(your_column) /60)
Instead of:
(UNIX_TIMESTAMP(NOW()) -