Need report like below

Databases
1

Hi,

i have table like this,

|-------------------------------------------------------------------|

CREATE TABLE products (
id int(11) NOT NULL auto_increment,
merchant varchar(255) NOT NULL default ‘’,
name varchar(255) NOT NULL default ‘’,
description text NOT NULL,
image_url varchar(255) NOT NULL default ‘’,
buy_url text NOT NULL,
price decimal(10,2) NOT NULL default ‘0.00’,
search_name varchar(255) NOT NULL default ‘’,
category varchar(255) NOT NULL default ‘’,
brand varchar(255) NOT NULL default ‘’,
dupe_hash varchar(32) NOT NULL default ‘’,
rating int(11) NOT NULL default ‘0’,
reviews int(11) NOT NULL default ‘0’,
PRIMARY KEY (id),
UNIQUE KEY dupe_filter (dupe_hash),
KEY merchant (merchant),
KEY name (name),
KEY search_name (search_name),
KEY category (category),
KEY brand (brand),
FULLTEXT KEY name_2 (name)
) ENGINE=MyISAM AUTO_INCREMENT=32185 DEFAULT CHARSET=utf8 AUTO_INCREMENT=32185 ;

|-------------------------------------------------------------------|

i need to display report as follows,( i need first sort by merchant & second brand)

Merchant | Brand | No. Of products( related to merchant & brand)

please reply soon,

Thanks in Advance.

Sunil.

2

It looks ok to me. But why asking, try it. Then, if it doesn’t work or gives the wrong info and you don’t understand why, come here and ask.

3

Hi,
i kept the query like this is it ok?

SELECT merchant, brand, count(*) no_of_products FROM comp_products where brand!=‘’ group by merchant,brand order by merchant, brand

please confirm me.

4

when in doubt, consult the manual. and again, with a SELECT, try it and see. An INSERT, UPDATE or DELETE you would want to try on a test table of course.

5

yes

6

Hi,

actually my doubt is, can i use two columns in one ‘Group By’.

Regards,
Sunil.