Comparing DateTime in MySQL

[Chuckie]

I don't understand why this is not working.

 function countHits()
     {
         global $wpdb;
         $query = "SELECT count(*) FROM ".$this->Table." WHERE time = 2005-02-26";
                 
         return $this->wpdb->get_var($query);
     } 

I also tried using MySQL function 'CURDATE()'. The value that keeps getting returned is '0'.

I am trying to return rows from a specific date.

Thanks,

Chuck

[r937]

WHERE time = 2005-02-26

requires quotes

otherwise, 2005-02-26 is 2005 minus 02 minus 26, which equals 1997, which isn't a valid datetime

[Chuckie]

WHERE time = 2005-02-26

requires quotes

otherwise, 2005-02-26 is 2005 minus 02 minus 26, which equals 1997, which isn't a valid datetime

opps..

I still can't get it to work. I am trying to select all the records from today, but I keep getting a count of '0'.

Here is what the statment looks like so far..

 SELECT  * 
 FROM b2stats
 WHERE time >= {fncurdate(  )}

[r937]

three things i can see wrong with that query

1. time is a reserved word and needs backticks
2. curly braces are not allowed
3. no such function as fncurdate

try this query --

select  * 
  from b2stats
 where `time` >= current_date

make sure you test your queries outside of php first, okay?

[Chuckie]

three things i can see wrong with that query

1. time is a reserved word and needs backticks
2. curly braces are not allowed
3. no such function as fncurdate

try this query --

select  * 
   from b2stats
  where `time` >= current_date

make sure you test your queries outside of php first, okay?

Thanks!

Here is what I am doing: http://www.cconway.com/wp-advanced-stats.php

Thanks again,

Chuck