Problems with query using variables HELP!!!

[siwy]

I hope somebody can help. I am trying to pull info from my db using form variable and it works fine except for the column which is the variable it doesn't show anything. here is the code.

$colname_Recordset6 = "1";
if (isset($HTTP_SESSION_VARS['february'])) {
$colname_Recordset6 = (get_magic_quotes_gpc()) ? $HTTP_SESSION_VARS['february'] : addslashes($HTTP_SESSION_VARS['february']);
}
mysql_select_db($database_rscontacts, $rscontacts);
$query_Recordset6 = sprintf("SELECT last_name, first_name, username, $february FROM february WHERE $february <> 'sorry' ORDER BY last_name ASC", $colname_Recordset6,$colname_Recordset6);
$Recordset6 = mysql_query($query_Recordset6, $rscontacts) or die(mysql_error());
$row_Recordset6 = mysql_fetch_assoc($Recordset6);
$totalRows_Recordset6 = mysql_num_rows($Recordset6);

last_name, first_name and username show just as they should no problem but i have no value for $february. what am i doing wrong?

[adrian_quah]

Siwy, try this:

$query_Recordset6 = sprintf("SELECT last_name, first_name, username, february FROM february WHERE $february <> 'sorry' ORDER BY last_name ASC", $colname_Recordset6,$colname_Recordset6);

previously it was $february...The reason for this is that the field name in ur table is 'february' and not '$february'.

Hope this helps.

[siwy]

thanks, but the column name isn't february it's the value of $february and when i look at its value it's correct but it returns nothing.
the column names are like feb1, feb2, feb3.... that's why i use $february instead of feb1 or feb2 or feb3.... because it changes with every rquest.