Selecting problem in MySQL

I'm passing a string into a query and I keep getting an error.

I'm completely stumped - can someone please tell me just how stupid I've been and help me find the solution.

I have a table listing all the monthsyear from my blog. The link then passes the monthyear string to the next page.

It grabs the variable :-

//	get the month year to be compiled
$_SERVER['QUERY_STRING'];
$publishBlogMonth = $_GET['publishmonth'];

Then I use this variable to get the list of all the contents that have that month and year:-

$query = "SELECT * FROM blog where blogMonthYear=".$publishBlogMonth." order by blogPermalink DESC";
$results=mysql_query($query);

It keeps returning and empty record set?

The monthyears are in the following format:-

nov 05

please help - i think it has to be something to do with the space between the month and the year. How can I get rid of it?

Just an idea.. I don't really know if is gonna make any difference...

Maybe try using single instead of double quotes?

$query = "SELECT * FROM blog where blogMonthYear='$publishBlogMonth' order by blogPermalink DESC";

thanks for the advice.

i'd been fiddling around with the quotes thing and it turns out i should have used a single then a double.

'".$publishBlogMonth."'

doh! must be a sign to get to bed - nearly midnight here in south korea