Gossamer Forum
Home : Products : Gossamer Links : Version 1.x :

Get DATE of oldest VALIDATE record?

Quote Reply
Get DATE of oldest VALIDATE record?
Hi,

I'd like to add a line to my site suggestion page that shows the date of the oldest entry waiting for validation, i.e.;

We are currently reviewing site suggestions from [ date = oldest record in Validate table ]

Also I'd like to be able to show the number of sites waiting for review, i.e.;

We currently have [ valsites = total records in Validate table ] sites waiting for review

Any assistance appreciated.
Thanks.
Shaun

Quote Reply
Re: Get DATE of oldest VALIDATE record? In reply to
qango,

I've found many helpful MySQL functions via the http://www.mysql.com....try searching for date difference.

Regards,

Eliot Lee