Difficult WHERE clause

[Xtremer360]

$query = "SELECT * FROM `top5` WHERE `lastUpdated` = ?";

 

What I'm trying to do is check it again the lastUpdated table and make sure there isn't a row with the same date AND MONTH as an already existing row.

 

Any ideas how to accomplish this. And yes I have lastUpdated as a date field type.

[Xtremer360]

A friend told me I should mention that the intention is to see if one of the rows has its month AND year matching the current month and Year.

[mike12255]

so you basically want to select all of the information from the record where the lastupdated field  equals the same date as the current day?

[mike12255]

Ok so when entering things into your lastupdated table i would do it like this:

 

$date = time(); // returns somthing like 1303156571

 

then when you query in another file to see if anything has been "last updated" on the current day you would do;

$current_date = time();

$sql = "SELECT * FROM top_5 WHERE lastupdated =".$current_date;

[Xtremer360]

Actually with the help of a good friend I was able to come up with what I needed and here it is hopefully for anyone can understand this and apply it if need be.

 

WHERE year(`lastUpdated`) = year(now()) AND month(`lastUpdated`) = month(now())

[mikosiko]

easy way

WHERE date_format(`lastUpdated`, '%Y%m') = date_format(now(), '%Y%m');

[Xtremer360]

Thank you!