parse eror

[lukeurtnowski]

Here is some php code, when I run it, I get this error.

You have an error in your SQL syntax near '=='') || (yr2==''))' at line

$year = $_GET['year']; 
$query1 = mysql_query("select * from MAKE where   

        ((yr1=='$year') || (yr2=='$year'))")  

        or die(mysql_error());

Can anyone clue me in to why this is happening?

[AndrewWest]

$year = $_GET['year'];
$query1 = mysql_query("select * from MAKE where
        ((yr1 == $year) || (yr2 == $year))")
        or die(mysql_error());

Try that. I removed the 's before the $year's.

[AndrewWest]

Also,

Are you using this thinking $_Get['year'] will produce the year?

$_Get is used for the url decode

index.php?year=1964

Would then make

$_Get['year'] qual to 1964

[lukeurtnowski]

Here's the problem, I have two combo boxes, the first one yas a name of year and lists some years, once a selection is made from the list (onchange=submit()), the second combo box should be populated based on which year was selected, thanks a lot