Re: timestamp

On Thu, 2003-08-21 at 22:23, John Taylor-Johnston wrote: > Not teasing, I know I could do this with some ready made script, but I want to make my own. > > I'm making a counter. > > CREATE TABLE counter ( > IPAddress VARCHAR NOT NULL , > RemoteHost VARCHAR NOT NULL , > TimeStamp TIMESTAMP NOT NULL, try not naming your timestamp column a reserved word... just a guess > Date VARCHAR NOT NULL > ) > > > Question 1, how do I create a timestamp, (My SQL above does not work.), if this is indeed what > I want to do. see above > Question 2, how can I read TimeStamp and if the elapsed time between visits is more than 60 > minutes, I insert a new record? umm... look at: http://us4.php.net/time and http://www.mysql.com/doc/en/DATETIME.html one thing to look out for is php and mysql deal with time in different ways, so you may have to do some conversion... but this should get you started. > Where do I start? the above 2 links.