time

[astralaaron]

I need to be able to out put the number of entries into mysql for the current day, does anyone have a good idea how to do that?

[boen_robot]

Keep track on the time of modification (as a DATETIME field in the tables in question), and make a query that selects entries on that date range. You can get the number of entries fetched from PHP itself. If you aren't going to use the data itself, but just want the number, then I think there may be a function in SQL that would return only that in a single column. I don't know which one exactly though. Try to search in the MySQL (or whatever) documentation for this.

[astralaaron]

Keep track on the time of modification (as a DATETIME field in the tables in question), and make a query that selects entries on that date range. You can get the number of entries fetched from PHP itself. If you aren't going to use the data itself, but just want the number, then I think there may be a function in SQL that would return only that in a single column. I don't know which one exactly though. Try to search in the MySQL (or whatever) documentation for this.

there are so many ways to store the date/time thats the thing that is confusing me.. should I use a time stamp? or MySQL's now() ??

[justsomeguy]

I prefer to use an integer field and PHP's time function.

[astralaaron]

I prefer to use an integer field and PHP's time function.

then how would you go about outputting the # of entries for the current day?

[justsomeguy]

You figure out the range of numbers that fall in the current day and select entries in that range. You can use mktime to get the value for a specific time and date.