From: "Joel" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, August 09, 2001 3:01 AM
Subject: Date calculations with php and mysql
> How do I find the elapsed time on a timestamp field?
SELECT NOW() - field AS elapsed FROM table?
Alex
--
Alex Page, I
IVILEGES ON *.* TO username@localhost IDENTIFIED BY 'password'
WITH GRANT OPTION;
This should only allow user 'username' to access the database from the local
machine.
Alex
--
Alex Page, IT Department, Solid State Logic
E-Mail: [EMAIL PROTECTED]
Phone: +
port to (say) Linux, you could have the program package
have a dependency on MySQL (this seems to work very well in Debian, not sure
about RPM-based distribution) which would do exactly the same - check for
MySQL on install, and install it invisibly if it's not there.
Hope this is of some use,
