gulamansari

Video Table Structure: CREATE TABLE IF NOT EXISTS `videos` ( `id` int(11) NOT NULL AUTO_INCREMENT, `video_title` varchar(255) COLLATE latin1_general_ci NOT NULL DEFAULT '', `video_description` varchar(255) COLLATE latin1_general_ci NOT NULL DEFAULT '', `video_keywords` varchar(255) COLLATE latin1_general_ci NOT NULL DEFAULT '', `video_thumbnail` varchar(255) COLLATE latin1_general_ci NOT NULL DEFAULT '', `video_file` varchar(255) COLLATE latin1_general_ci NOT NULL, `video_url` text COLLATE latin1_general_ci NOT NULL, `category_id` int(11) NOT NULL DEFAULT '0', `final_rating` float NOT NULL DEFAULT '0', `video_date` date NOT NULL DEFAULT '0000-00-00', `video_status` int(11) NOT NULL DEFAULT '0', `hit` int(11) NOT NULL, `activate_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `mem_id` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT ; ***************************************************** Articles Table......... CREATE TABLE IF NOT EXISTS `article` ( `art_id` int(11) NOT NULL AUTO_INCREMENT, `category_id` int(11) NOT NULL, `art_title` varchar(255) NOT NULL, `art_desc` text NOT NULL, `art_thumbnail` varchar(100) NOT NULL, `art_url` varchar(255) NOT NULL, `final_rating` float NOT NULL, `art_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `art_status` int(4) NOT NULL, `hit` int(11) NOT NULL, `mem_id` int(11) NOT NULL, PRIMARY KEY (`art_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT ; ****************************************************** Picture Gallery Table--- CREATE TABLE IF NOT EXISTS `picture_gallery` ( `g_id` int(11) NOT NULL AUTO_INCREMENT, `category_id` int(11) NOT NULL, `gallery_title` varchar(255) NOT NULL, `gallery_desc` varchar(255) NOT NULL, `gallery_thumbnail` varchar(100) NOT NULL, `picture_url` varchar(255) NOT NULL, `final_rating` float NOT NULL, `gallery_date` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00', `gallery_status` int(4) NOT NULL, `hit` int(11) NOT NULL, `activate_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `mem_id` int(11) NOT NULL, PRIMARY KEY (`g_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMEN; *********************************************************** Games Table Structure--------- CREATE TABLE IF NOT EXISTS `games` ( `id` int(11) NOT NULL AUTO_INCREMENT, `game_title` varchar(255) NOT NULL, `game_desc` text NOT NULL, `game_keywords` varchar(255) NOT NULL, `game_thumbs` varchar(100) NOT NULL, `game_file` varchar(255) NOT NULL, `game_url` varchar(255) NOT NULL, `category_id` int(11) NOT NULL, `final_rating` float NOT NULL, `game_date` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00', `game_status` int(4) NOT NULL, `hit` varchar(40) NOT NULL, `activated_date` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00', `mem_id` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT; These are the All Table Structures in which have to get join and retrieve all data

hi, i want to retrieve data multiple table using joining. All table has different field name only one field is common example (category_id). so please help me i sending attachment image. data will be show like this image.. [attachment deleted by admin]