excluding a particular record from a results set

[tempyyyst]

Hello all

I have a query that retrieves a set of company data:

SELECT DISTINCT company, url, info, logosmall FROM company LEFT JOIN award_ceremony ON award_ceremony.sponsor=company.id WHERE award_ceremony.ceremony_id=8 ORDER BY company

What I want to do is exclude a particular company by id, so I tried...

SELECT DISTINCT company.id, company, url, info, logosmall FROM company LEFT JOIN award_ceremony ON award_ceremony.sponsor=company.id WHERE award_ceremony.ceremony_id=$currentid WHERE company.id NOT 5 ORDER BY company

Which to not much surprise on my part just caused an error.

Do I do this with a WHERE statement, in which case where does it go and what's the syntax?

Thanks in advance for any help.

[Cam]

SELECT DISTINCT company.id, company, url, info, logosmall FROM company
LEFT JOIN award_ceremony ON award_ceremony.sponsor=company.id
WHERE award_ceremony.ceremony_id={$currentid}
	AND company.id <> 5
ORDER BY company

Try that, it should work for you

[tempyyyst]

Thanks,

What if I want to exclude more than 1 id?

 AND company.id <> 5,1

???

[redemption]

You can do something like this:

AND company.id NOT IN (5, 1, 23)