Date

[_matrix_]

Hi,

Im trying to grab all records that match the month from:

$eventid = '2007-05-11';

using query:

$sql = mysql_query("SELECT id, firstname, lastname, phone, cellphone, email, starttime, finishtime, event FROM calendar WHERE MONTH(starttime) LIKE '".$eventid."%' ORDER BY starttime ASC");

Seems to bring back zero rows when there are 2 rows iin he database matching the 5th month.

Have I got it all wrong?

Thanks

[abb]

Should be
MONTH(starttime) = MONTH($eventid)
Also you might want to check for year too

To understand what MONTH(), YEAR() does, simple run SELECT MONTH('2007-05-11'); on your MySQL frontend tool

[Akash Mehta]

Do you mean $eventid = '2007-05-' to grab any day within the fifth month of 2007?

[_matrix_]

Works using:

WHERE MONTH(starttime) = '$monthnum' && YEAR(starttime) = '$year'

Thanks

[r937]

if you care about performance (i.e. to avoid table scans) then your query should look like this --

select ...
  from ...
 where starttime >= '2007-05-01'
   and starttime  < '2007-06-01'

this way, an index on the starttime column can be utilized