filter by multiple attributes

Posted by cosy on Stack Overflow See other posts from Stack Overflow or by cosy
Published on 2010-04-22T13:58:46Z Indexed on 2010/05/10 18:04 UTC
Read the original article Hit count: 247

Filed under:
|

I have the table :

id id_products id_atribut   name     value
1     13          8        autdio      2.1
2     13          9        hdd         200 Gb
3     13          10       cd-rom       2
4     20          8         audio       2.1

the problem is, how can i select from this table where name="audio" and value="2.1" and name="hdd" and value="200 gb" and return id_products=13 ....

How can i do this?

© Stack Overflow or respective owner

Related posts about php

Related posts about sql