Today added

[domic]

Hy,

In my mysql database is row date, and it is in format 00-00-00 00:00:00

And I want, in php file, show how many items is added today...

So, $query="SELECT * FROM table WHERE date="[b]TODAY[/b]"";

how to put this correctly?

[todd3834]

[!--quoteo(post=371044:date=May 3 2006, 01:11 PM:name=domic)--][div class=\'quotetop\']QUOTE(domic @ May 3 2006, 01:11 PM) [snapback]371044[/snapback][/div][div class=\'quotemain\'][!--quotec--]
how to put this correctly?
[/quote]

$query="SELECT * FROM table WHERE date=NOW();";

As long as your dates use the format 00-00-00 00:00:00 then you use the NOW() function in MySQL

instead of [b]TODAY[/b] use [b]NOW()[/b]

The two functions that may be helpful to anyone reading this would be NOW() and CURDATE()

[b]NOW()[/b] will return the date/time in the format "00-00-00 00:00:00"

[b]CURDATE()[/b] will return the date in the format "0000-00-00"

[Caesar]

But it's always easier if your dates were stored in the form of unix timestamps...that way, queries are easy as pie...and you can do any date formatting you want, [i]after[/i] you pull the data from the db. :-)

[domic]

Ok, but I don't need "now", i only want today, so from that date i need this 00-[b]00[/b]-0000 00:00:00

Because, if I use this variable: $num=mysql_numrows($result); it will always be 0.