SQL Statement Problems - Month & Year

[skadera]

I am trying to retirve the numbers of records for a specific user for the current month and year. Does anyone see a problem with is statement:

 
$monthsessions = mysql_result(mysql_query("SELECT COUNT(*) FROM login WHERE track_users_ID = '$users_ID' AND MONTH(track_date()) = MONTH(CURDATE()) AND YEAR(track_date()) = YEAR(CURDATE())"),0); 

[PHP John]

Is "track_date()" a function that you created? If it is, as far as I know, it will not work within the query.

[skadera]

Thanks fot the reply

track_date is a datetime field in my database.

the format of the field is 0000-00-00 00:00:00

I just assumed that because it is a date it should work the same way. Should I do something different?

[PHP John]

You have track_date written as a function call. This would cause problems.

I have found the easiest way to work with dates is to store them as a timestamp and then format them as needed with the date() function.

This is my preference.

[redemption]

What PHP John means is that your query should be like this:

SELECT COUNT(*)
FROM login
WHERE track_users_ID = '$users_ID'
  AND MONTH(track_date) = MONTH(CURDATE())
  AND YEAR(track_date) = YEAR(CURDATE())

[PHP John]

Thanks, Redemption!

I'm not at all familiar with the mySQL date functions.

[redemption]

Don't thank me. I didn't really do anything if you take a look at the query. I just removed the '()' from the end of track_date() like you said.

[skadera]

Cool! It is working now.

Thanks,
Scott