stupid where clause question

[Adamthenewbie]

How do you use the where clause with a variable??
This is what I have

$result2 = mysql_query("SELECT fullDate, prov_state, city, country, raceDesc,id FROM resultDB WHERE month = " + $monthSearch + " AND year = " + $yearSearch + " order by startDay DESC", $mysql_access);

I also tried this

$result2 = mysql_query("SELECT fullDate, prov_state, city, country, raceDesc,id FROM resultDB WHERE month = monthSearch AND year = $yearSearch order by startDay DESC", $mysql_access);

[kevinsequeira]

<?php
 $result2 = mysql_query("SELECT fullDate, prov_state, city, country, raceDesc, id FROM resultDB WHERE month = '".$monthSearch."' AND year = '".$yearSearch."' order by startDay DESC", $mysql_access);
// if year and month are stored as numbers then remove the ' ' on either side of variable names like this
 $result2 = mysql_query("SELECT fullDate, prov_state, city, country, raceDesc, id FROM resultDB WHERE month = ".$monthSearch." AND year = ".$yearSearch." order by startDay DESC", $mysql_access);
?>

reg
kevin

[fahrvergnuugen]

if you're matching non integers use this:

$query = "select * from table where column1 = 'value1' and column2 = 'value2'";