Received: by 10.66.85.136 with SMTP id h8mr373840paz.46.1349252812667;
        Wed, 03 Oct 2012 01:26:52 -0700 (PDT)
Received: by 10.68.233.130 with SMTP id tw2mr1051271pbc.12.1349252812649; Wed,
 03 Oct 2012 01:26:52 -0700 (PDT)
Path: t10ni23606524pbh.0!nntp.google.com!kt20no7698041pbb.1!postnews.google.com!glegroupsg2000goo.googlegroups.com!not-for-mail
Newsgroups: comp.databases.oracle.server
Date: Wed, 3 Oct 2012 01:26:52 -0700 (PDT)
Complaints-To: groups-abuse@google.com
Injection-Info: glegroupsg2000goo.googlegroups.com; posting-host=49.204.56.84; posting-account=WFhukwoAAABzaKbOGXbujDqRC1VfNsnD
NNTP-Posting-Host: 49.204.56.84
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <4430475b-72a1-469a-99bf-a9fa94416d55@googlegroups.com>
Subject: sql-mysql
From: sudheer.puthine...@gmail.com
Injection-Date: Wed, 03 Oct 2012 08:26:52 +0000
Content-Type: text/plain; charset=ISO-8859-1

hi
I have subjects table like this

CREATE TABLE IF NOT EXISTS `subjects` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `code` varchar(255) DEFAULT NULL,
  `typename` varchar(255) DEFAULT NULL,
  `status` varchar(255) DEFAULT NULL,
  `credits` int(11) DEFAULT NULL,
  `max_external_marks` int(11) DEFAULT NULL,
  `max_internal_marks` int(11) DEFAULT NULL,
  `max_assignment_marks` int(11) DEFAULT NULL,
  `max_sessional_marks` int(11) DEFAULT NULL,
  `periods_in_week` int(11) DEFAULT NULL,
  `continuous_periods` int(11) DEFAULT NULL,
  `year` date DEFAULT NULL,
  `selected_terms` varchar(255) DEFAULT NULL,
  `select_semester` varchar(255) DEFAULT NULL,
  `available_instructers` varchar(255) DEFAULT NULL,
  `selected_instructers` varchar(255) DEFAULT NULL,
  `csv_file_name` varchar(255) DEFAULT NULL,
  `semester_id` int(11) DEFAULT NULL,
  `department_id` int(11) DEFAULT NULL,
  `organization_id` int(11) DEFAULT NULL,
  `division_id` int(11) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=69 ;

it is having  some data in it

now I want display like

Student_id subject(1) subject(2) subject(3)
460        12         17         19