Select AS question

Hello to All,

I've been trying something like this and it doesn't work:

SELECT *,idcat AS cat,idsubcat AS subcat FROM products WHERE 11 IN (cat) AND 34 IN (subcat) AND active!='no'

This is the error it gives me: Unknown column 'cat' in 'where clause'

Any suggestions would be greatly appreciated!

To give you more details this works:

SELECT * FROM products WHERE FIND_IN_SET('$idcat', idcat) AND FIND_IN_SET('$idsubcat', idsubcat) AND active!='no'

But I've read it can return false positives so that's why I was trying to find a workaround... Any comments?

Thank you!
Andie

[Join us @ facebook]

The part "WHERE 11 IN (cat)" should be "WHERE cat IN (11)" or even better "WHERE cat = 11"

Thanks for the reply, but cat and subcat are comma separated values pulled from the database so I can't do it the way you mention.

why not try:
SELECT idcat AS cat && idsubcat AS subcat FROM products WHERE 11 IN (cat) AND 34 IN (subcat) AND active!='no'

i dont know if it'll help.. just sharing my thoughts

What RDMS you are using?? May be you have to search it on Google...

can you please show me the values of table?

've been trying something like this and it doesn't work:

SELECT *,idcat AS cat,idsubcat AS subcat FROM products WHERE 11 IN (cat) AND 34 IN (subcat) AND active!='no'

This is the error it gives me: Unknown column 'cat' in 'where clause'

Any suggestions would be greatly appreciated!

this is very much nice to have such an important source of information to have...

[Guest]

[59.827]

Googlebot, avasheshid1, SamyJones, juanhazelgrove