--
-- Table structure for table `column_ads`
--

CREATE TABLE IF NOT EXISTS `column_ads` (
`id` int(5) NOT NULL AUTO_INCREMENT,
`column_id_1` int(10) NOT NULL,
`column_id_2` int(10) NOT NULL,
`column_id_3` int(11) NOT NULL,
`column_id_4` int(11) NOT NULL,
`column_id_5` int(11) NOT NULL,
`column_id_6` int(11) NOT NULL,
`column_id_7` int(11) NOT NULL,
`column_id_8` int(11) NOT NULL,
`column_id_9` int(11) NOT NULL,
`page_id` int(5) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=9 ;

--
-- Dumping data for table `column_ads`
--

INSERT INTO `column_ads` (`id`, `column_id_1`, `column_id_2`, `column_id_3`, `column_id_4`, `column_id_5`, `column_id_6`, `column_id_7`, `column_id_8`, `column_id_9`, `page_id`) VALUES
(1, 6, 2, 3, 2, 3, 3, 3, 3, 3, 1),
(8, 2, 2, 3, 2, 3, 3, 3, 3, 3, 34);

--
-- Table structure for table `advertisement`
--

CREATE TABLE IF NOT EXISTS `advertisement` (
`ad_id` int(11) NOT NULL AUTO_INCREMENT,
`title` varchar(60) NOT NULL,
`script` text NOT NULL,
`created_on` varchar(30) NOT NULL,
PRIMARY KEY (`ad_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ;

--
-- Dumping data for table `advertisement`
--

INSERT INTO `advertisement` (`ad_id`, `title`, `script`, `created_on`) VALUES
(3, 'gghf', '<html><title>hello</title></html>', 'March 22, 2010, 6:56 am'),
(2, 'sofent', '<script typefghf="text/javascript>\r\nhi</script>', 'March 22, 2010, 6:51 am'),
(5, 'vcbcvb', '<html><title>hello</title></html>', 'March 23, 2010, 8:37 am'),
(6, 'fdg', '<html><title>hello</title></html>', 'March 23, 2010, 9:47 am');

Actually
i need to extract the data from script column from advertisement table..

notes: column_id_1,....column_id_9 from column_ads table holds advertisement table ad_id data.
i need to extract the script from advertisement table by column_id_1---column_id_9 where page_id = (example:1)

output like:

column_id_1-->2 means i want to extract <script typefghf="text/javascript>\r\nhi</script> bec ad_id is 2