[SOLVED] Unknown column in where clause

[jeff5656]

In my database table I have a variable called which_month.  The values are November, December, etc.

I want the following code to pull the record with with the current month, but when I run this code I get: "Invalid query: Unknown column 'November' in 'where clause'"

 

<?php 
include ("../connectdb.php");
$curr_month = date (F);
$consultsq1 = "SELECT * FROM `staffsched` WHERE `which_month` = $curr_month";
$result = mysql_query ($consultsq1) or die ("Invalid query: " . mysql_error ());
$row = mysql_fetch_array ($result);
?>

[marcus]

$consultsql = "SELECT * FROM `staffsched` WHERE `which_month`='".$curr_month."'";

[revraz]

Means you forgot single quotes around the $curr_month variable.

[marcus]

What revraz said It's common to forget quotes, just use them when you can to escape information, makes error checking a lot easier