Todays Database Entries?

[Warptweet]

In my database, one of the columns is "date".

 

The date uses the TIMESTAMP( code, which means it stores the date that the row was created.

How would I be able to find how many rows were entered the particular day? (E.G. How many today, when it's tommorow, it will display how many were uploaded tommorow, and so forth)

 

And once it does that, display a NUMBER of how many rows were entered today?

 

EXAMPLE OF TIMESTAMP(:

2007-02-24 21:14:50

 

Thats an example of what TIMESTAMP( does, you can use that to find how many rows were entered today.

[bwochinski]

SELECT COUNT(*) FROM your_table WHERE date >= CURDATE()

[Warptweet]

Is that SQL? Or is that PHP?

[Archadian]

mysql_query("SELECT COUNT(*) FROM your_table WHERE date >= CURDATE()")

[bwochinski]

That's your SQL.

The PHP is something like:

 

<?php
$count_res = mysql_query("SELECT COUNT(*) FROM your_table WHERE date >= CURDATE()");
$count = mysql_result($count_res,0);
?>

 

And there's your "$count"