displaying only certain items in a sql database

[svgmx5]

What i have is a list of events, which are all stored on a database and are retrieve using php.

 

The issue i'm having is that i want it so people can click on a month, like January and all the events for January will be displayed.

 

I wrote a script but i'm not sure what i'm doing wrong that is not doing what i was hoping it was.

 

So i hope someone here can point me to the right direction and look over my script to see what i'm doing wrong

 

$sql = "SELECT * FROM workshops WHERE month='$month'";
$run = mysql_query($sql) or die(mysql_error());
$num = mysql_num_rows($run);
                  	
while($fetch = mysql_fetch_assoc($run)) {
$date = $fetch['date'];
$title = $fetch['title'];
$moderator = $fetch['moderator'];
$location = $fetch['location'];
$time = $fetch['time'];
$cost = $fetch['cost'];

[spfoonnewb]

It looks fine to me. What is it doing wrong? is there more to it?

[svgmx5]

yea sorry i forgot that part

 

What is doing is just displaying all events, even those that are not on january

[spfoonnewb]

Is $month defined, and what column type is the month stored in? is it stored as a number "01" or text "January"?

[svgmx5]

well month is stored as text  and the type is varchar.