SQL help

[jcarruthers]

This one must be simple... but I can't get my head around it...

Background stuff:


Each record has 2 fields - passed and user

If you login as admin - you see everything - that works ok... simple enough...

But if you login as a standard user then you only see records that have passed and your own records - regardless if they are passed or not.

My rubbish stab at this:

  AND (file.passed <> '0' OR file.user = '".$user."')";

James

[sylow]

file.passed <> '0' or (file.user = '".$user."') or ('".$user."' = 'admin')