Need help with substr function

[badgoat]

Hello!

What I'm trying to do is to display the number of events per day on a PHP calendar. The events are entered into my db with a column called 'diw_depdate' which contains a date in 'YYYY-MM-DD' format. Using the substr function, I was trying to display the correct # of events per day in the matching calendar day.

$query = "SELECT COUNT(*) FROM diw WHERE '.$Year.' = substr($diw_depdate,0,4) AND '.$Month.' = substr($diw_depdate,6,2) AND '.$calendar_day.' = substr($diw_depdate,9,2)";
        $numdeps = mysql_query($query) or die("Select Failed!");
        $numdep = mysql_fetch_array($numdeps);

With the above code I get this error:
Notice: Undefined variable: diw_depdate in c:\phpdev5\www\newtad\main.php on line 192
Select Failed!

I've never used the substr function before, and to me it's complicated when trying to use it in an MSSQL query.

Any guidance is much appreciated.

[devinemke]

you do not need substr for this

$result = mysql_query('SELECT diw_depdate, COUNT(*) AS count FROM diw GROUP BY diw_depdate') or exit(mysql_error()); 
while ($row = mysql_fetch_assoc($result))
{
 		  echo $row['diw_depdate'] . ' ' . $row['count'] . '<br>';
}

[badgoat]

Hiya devinemke,

That's certainly a step in the right direction, now I do see data in the boxes for each day on the calendar, but it is all the exact same data in each box. for example, I wanted it to say "3 Events" if there are three events planned for any given day. As the script works now, it displays each 'diw_depdate' in every box on the calendar. A sample of the display:

2006-02-13 2
2006-02-14 1
2006-02-15 1

There are two events on 2/13/06, 1 on 2/14 and 1 on 2/15. These three lines are in each box of the calendar. Am I missing something else?

[devinemke]

the code i posted is just an example of how to get the raw data (dates and counts). how you format that data is up to you.