SQL select statement

[lukeurtnowski]

I'm trying to perform a select on a database to find out if the values of the yr1 and r2 have been seleccted, heres the code

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

[tommynanda]

$year = $_GET['year'];
$query1 = mysql_query("select yr1, yr2, Make from MAKE where  

        ((yr1=='$year') || (yr2=='$year'))") 
        or die(mysql_error());

Note the change of quotes;

be careful with case-sensitivity...(MAKE)

TommYNandA

[lukeurtnowski]

thanks, is it important that I select both r1 and yr2 at the very beginnning of the select statement?

[tommynanda]

Do you mean SELECT yr1, yr2,... ?
If thats your Q... yeah if you want to retrieve those values you have to ... or if you have no use with those value u can just ignore. them

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

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

        or die(mysql_error());

This retrieves Column Make from MAKE of a row(s) that satisfies your condition

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

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

        or die(mysql_error());

This retrieves all columns from MAKE of a row(s) that satisfies your condition

Good Luck
TommYNandA

[lukeurtnowski]

I used the exact code, and got this error message.
You have an error in your SQL syntax near '=='') || (yr2==''))' at line 2