Exclude a record from the table to be displayed.

[art15]

Hi all,

 

I am trying to display the result from table excluding a single result where piD='donotshow'.

the query I have is as follows;

$sSQL = "SELECT DISTINCT products.pID NOT IN(products.pID='donotshow') ,pName,pDisplay,pSell,pInStock,rootSection,pStockByOpts " . $sSQL;

the query doesnt give any error, however it does not show the pID's at all.

 

Please help.

 

thanks

 

[art15]

Hi Guys

 

Please reply.

 

I have the same thing working on another page where the query is "select pID from products where pID not in ('donotshow' ) ";

 

thanks

[aschk]

What does your full query string look like (without the . concats, i.e. echo it)? And, why are you using DISTINCT as you appear to be getting all your information from the products table? And why is your NOT IN part of the SELECT clause? It's a WHERE clause...

Also DON'T use NOT IN as I suspect it's less efficient than using "WHERE products.pID != 'donotshow' "...