A JOIN using WHERE, AND, OR and parentheses

[facarroll]

I have a search box which sets a choice out of three "sounds like" inputs. The variable which represents these is $strInfo .

It should work but doesn't select anything, though there is no error message. I suspect the problem might be "AND WHERE".

$sql = "SELECT quiz.*, users.id, users.userGroup, users.family, users.given 
FROM quiz,users 
WHERE quiz.userIdRec=users.id 
AND WHERE (quiz.quizTitle LIKE '%".$strInfo."%' OR quiz.userId LIKE '%".$strInfo."%' OR quiz.userGroup LIKE '%".$strInfo."%')
AND quiz.managerId = '1' 
AND users.userGroup != 'exStudent' 
ORDER BY users.family, users.given, quiz.quizTitle quiz.addDate, quiz.passState ASC ";

Can anyone suggest a correction?

[PravinS]

Remove "AND WHERE", just use "AND"

[facarroll]

Thanks to pbs. This worked.

$sql = "
	  SELECT quiz.*, users.id, users.userGroup, users.family, users.given  
	  FROM quiz, users
	  WHERE quiz.userIdRec = users.id
	  AND (quiz.quizTitle LIKE '%".$strInfo."%' OR quiz.userId LIKE '%".$strInfo."%'  OR quiz.userGroup LIKE '%".$strInfo."%') 
	  AND quiz.managerId = '".$userid."' 
	  AND users.userGroup != 'exStudent' 
	  ORDER BY users.family, users.given, quiz.quizTitle, quiz.addDate, quiz.passState  ASC ";