PHP DB - Dates and Count

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Dates and Count

Shannon Doyle

2004-06-27, 3:55 pm

Hi People,

I have two queries for the list:-

First, I have two dates stored in a MySQL DB that I want to do a compare on
and then only display via a web page those records that have a 5 or greater
day difference in them. What would be the best way to achieve this.

Second, I want to be able to return a list of 'clients' from the MySQL DB
that have a specific number of a particular type of entry associated with
them. I am assuming that the 'count' would be used, but how would I first
display this count, and second only return those that have the number of
entries that I am looking for.

Thanks in advance

Shannon

Sponsored Links