query help

Query

[smartie]

Hi All

I am trying to query a database i have a field column called awards in my database and trying to query

$where = join($subjectChecked, ' = "y" OR ') . ' = "y"';

//Create Query
$query = "SELECT * FROM partnership WHERE $where and awards="Y";
$result = mysql_query($query) or die (mysql_error());

the error is
Parse error: parse error, unexpected T_STRING in /home/charity/public_html/nigel/check9.php on line 28

thanks for any help

Nigel

[smartie]

ok sorted

$query = "SELECT * FROM partnership WHERE $where AND awards='y' ";