0zyJ0ztW

1$cccc=intval($_GET['cat']);
2$DB = new DB;
3$seleddcddddtMainwork ="select id from sub where mainid='$cccc' as iiid from ads where cat='$idididid' order by id desc limit 10  ";
4	
5select sub.mainid='$cccc' as idididid  from ads where cat='$idididid' order by id desc limit 10
6	
7CREATE TABLE IF NOT EXISTS `ads` (
8  `id` int(255) NOT NULL AUTO_INCREMENT,
9  `userid` int(255) NOT NULL,
10  `title` varchar(255) NOT NULL,
11  `photo` varchar(255) NOT NULL,
12  `message` varchar(255) NOT NULL,
13  `price` int(255) NOT NULL,
14  `contery` varchar(255) NOT NULL,
15  `mobile` varchar(255) NOT NULL,
16  `showmobile` int(255) NOT NULL,
17  `showj` int(255) NOT NULL DEFAULT '0',
18  `youtuube` varchar(255) NOT NULL,
19  `cat` int(255) NOT NULL,
20  PRIMARY KEY (`id`),
21  KEY `photo` (`photo`),
22  KEY `title` (`title`),
23  KEY `message` (`message`),
24  KEY `price` (`price`),
25  KEY `contery` (`contery`),
26  KEY `mobile` (`mobile`),
27  KEY `showmobile` (`showmobile`),
28  KEY `show` (`showj`),
29  KEY `youtuube` (`youtuube`),
30  KEY `userid` (`userid`),
31  KEY `cat` (`cat`)
32) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
33
34
35CREATE TABLE IF NOT EXISTS `sub` (
36  `id` int(11) NOT NULL AUTO_INCREMENT,
37  `name` varchar(255) NOT NULL,
38  `mainid` int(255) NOT NULL,
39  PRIMARY KEY (`id`),
40  KEY `name` (`name`),
41  KEY `mainid` (`mainid`)
42) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=126 ;
43	
44select id from sub.mainid='$cccc' as idididid  from ads where cat='idididid' order by id desc limit 10
45	
46SELECT sub.id, sub.mainid
47FROM sub                                                                                     
48WHERE sub.mainid =  '2'
49	
50$cccc=intval($_GET['cat']);
51$DB = new DB;
52$seleddcddddtMainwork ="select S.id from sub S JOIN ads A ON S.mainid=A.id AND C.cat='$idididid' AND S.mainid='$cccc' order by S.id desc limit 10";
53	
54$cccc=intval($_GET['cat']);
55$DB = new DB;
56$seleddcddddtMainwork ="select S.id, S.name, S.mainid, A.message, A.price from sub S JOIN ads A ON S.id=A.mainidAND C.cat='$idididid' AND S.mainid='$cccc' order by S.id desc limit 10";
57	
58$cccc=intval($_GET['cat']);
59$DB = new DB;
60$seleddcddddtMainwork ="select S.id, S.name, S.mainid as iit, A.message, A.price from sub S JOIN ads A ON S.mainid=A.cat AND S.mainid='$cccc' order by A.id desc limit 10";