php, sql selection

Question

I have a stupid question, I have this table :

id_product    name        value
   1          price       10-20
   1          type        computer
   2          price       20-30
   3          price       100-200

and I want to select from this table GROUP BY id_product and ORDER BY value WHERE name='price'

how can i do this?

Thanks a lot

Answer 1

SELECT * 
FROM table_name 
WHERE name = 'price'
GROUP BY id_product
ORDER BY value

You can see this for MySQL Select syntax

Answer 2

select * from table_name where name='price' Group By id_product ORDER By value;

Answer 3

select * from table_name  WHERE name='price' 
    GROUP BY id_product
    ORDER BY value

In PHP

mysql_query("select * from table_name  WHERE name='price' 
        GROUP BY id_product
        ORDER BY value") or die(mysql_error());

Answer 4

right off the top of my head...

does it work?

SELECT * FROM `table` WHERE `table`.`name`='price' GROUP BY `table`.id_product ORDER BY `table`.`value` ASC

Answer 5

It depends on how you want to group items with the same id: which one do you want to be shown? In theory GROUP BY shouldn't be used with SELECT * (it does not work with non mysql databases) and should be associated with aggregate funcions such as COUNT(), MAX(), etc.

You might just need SELECT DISTINCT instead of GROUP BY.