sql-mysql

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 Received on Wed Oct 03 2012 - 10:26:52 CEST