Re: selecting what NOT in the table..

2004-05-28 Thread Brent Baisley
Why not search on if it's there, if no results are returned, you know it's not there. SELECT count(*) as langcount from db where lang=$lang; If you want to check for multiple items at once: SELECT count(*) as langcount from db where lang in ('lang1', 'lang2', ...) Since you don't want to actual

selecting what NOT in the table..

2004-05-28 Thread LR Sieting
Hello, I have several tables that have a common column. I need to check those tables for 1 of 4 items. If that item does not exist, I jump to a page saying it is coming soon... I am passing a variable ($lang) around using php to select info based on that column. what would be a suggested sel