daGrevis Posted November 17, 2011 Report Share Posted November 17, 2011 Parādi savas tabulas struktūru. Quote Link to comment Share on other sites More sharing options...
Blumish Posted November 17, 2011 Author Report Share Posted November 17, 2011 (edited) CREATE TABLE ca_caught ( id INT NOT NULL AUTO_INCREMENT, title TEXT character set utf8 collate utf8_unicode_ci NOT NULL, text TEXT character set utf8 collate utf8_unicode_ci NOT NULL, img VARCHAR(300) character set utf8 collate utf8_unicode_ci NOT NULL, video VARCHAR(300) character set utf8 collate utf8_unicode_ci NOT NULL, type INT(2) NOT NULL, votefor INT NOT NULL, voteagainst INT NOT NULL, time INT NOT NULL, author INT NOT NULL, lang VARCHAR(5) character set utf8 collate utf8_unicode_ci NOT NULL, category INT(2) NOT NULL, voters TEXT, FULLTEXT (voters), PRIMARY KEY(id) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 Edited November 17, 2011 by Blumish Quote Link to comment Share on other sites More sharing options...
marcis Posted November 17, 2011 Report Share Posted November 17, 2011 Kāpēc? Kas vainas WHERE klauzam?! Es domāju, ka viņš grib overall statistiku vienā lapā parādīt, tādā gadījumā GROUP BY vienam selektam, nevis 3 selekti ar WHERE Quote Link to comment Share on other sites More sharing options...
daGrevis Posted November 17, 2011 Report Share Posted November 17, 2011 Tādā gadījumā tā gan laikam būs, Mārci. Bluminjšššš, skaidrs, ka neiet. Tev tips 'type' kolonai ir integer. Tad arī salīdzini kā integer. Quote Link to comment Share on other sites More sharing options...
Blumish Posted November 17, 2011 Author Report Share Posted November 17, 2011 Bluminjšššš, skaidrs, ka neiet. Tev tips 'type' kolonai ir integer. Tad arī salīdzini kā integer. tad man WHERE vieta jaliek integer ja? Quote Link to comment Share on other sites More sharing options...
daGrevis Posted November 17, 2011 Report Share Posted November 17, 2011 WHERE `type` = 0 Vai 1, 2, 3, 4... es taču nezinu kāds skaitlis tev atbilst 'pictures' un kāds - 'videos'. Quote Link to comment Share on other sites More sharing options...
Blumish Posted November 17, 2011 Author Report Share Posted November 17, 2011 WHERE `type` = 0 Vai 1, 2, 3, 4... es taču nezinu kāds skaitlis tev atbilst 'pictures' un kāds - 'videos'. taspats errors Quote Link to comment Share on other sites More sharing options...
viena tante Posted November 19, 2011 Report Share Posted November 19, 2011 (edited) taspats errors 'tāāābūūlāāā' vietā jāliek Tavs tabulas nosaukums :D Edited November 19, 2011 by viena tante Quote Link to comment Share on other sites More sharing options...
daGrevis Posted November 19, 2011 Report Share Posted November 19, 2011 Un tas viss ir jāieliek funkcijā/metodē, kas izpildīs MySQL pieprasījumu uz tavu datubāzi. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.