Hi everybody, I dont know, if it's been asked before, I was looking for the syntax to fetch dynamic no of column, which are actually the record values. I dont know, if it's possible with mysql as it doesn't yet provide sub-query feature (prod ver).
I need to select a column's value as different columns and other fields grouped by those values. Below is the table str., I'll appreciate any suggestions or links to look for. Str. CREATE TABLE presignup ( packno varchar(6) NOT NULL default '', signid varchar(12) NOT NULL default '', signpass varchar(12) NOT NULL default '', plancode varchar(20) NOT NULL default '', reseller varchar(20) NOT NULL default '', PRIMARY KEY (packno) ) TYPE=MyISAM; I want to select distinct values of reseller column as individual columns and other data grouped on these values. Thanx in advance Nitin
