SkyD Posted December 27, 2005 Report Share Posted December 27, 2005 hmm..Piem ir ieraksts, kas izvilkts no mysql.. Un ierakstam blakus ir vajadziigs <a href="dzest.php?id=te ieraksta id"> kad taisiju tabulu pieliku klat.. id INT NOT NULL AUTO_INCREMENT,. Domaaju, ka peec taa arii var izdzeest, bet kaa??!! Kaa lai es tajaa linkaa noraadu preciizo ID!?? Tur vajag ar to ORDER BY id?? Link to comment Share on other sites More sharing options...
Kavacky Posted December 27, 2005 Report Share Posted December 27, 2005 Vienalga pēc kā kārtot, tu sameklē vajadzīgo ierakstu, piemēram, kur `vārds`='Vasīlijs', paņem tā ieraksta id un drukā tajā linkā. Link to comment Share on other sites More sharing options...
SkyD Posted December 28, 2005 Author Report Share Posted December 28, 2005 Nu taa mieriigi visu apdomaajot, kaa tas izskataas izdomaaju arii.. bet paldies=]~~ Link to comment Share on other sites More sharing options...
SkyD Posted December 28, 2005 Author Report Share Posted December 28, 2005 hmm.. bet kaada komanda japielieto, lai saskaitiitu cik useri ir tabulaa "user" un cik piem kb aiznjem visi ieraksti tabulaa "ieraksti"... Link to comment Share on other sites More sharing options...
Grey_Wolf Posted December 28, 2005 Report Share Posted December 28, 2005 SELECT count(*) as skaits_kopa FROM tabula WHERE nosacijums Link to comment Share on other sites More sharing options...
SkyD Posted December 28, 2005 Author Report Share Posted December 28, 2005 " as skaits_kopa" nesaprotu to.. bet man jau vajag dabuut to skaitu, kaa es varu vinju noraadiit, ja nezinu ..!! Link to comment Share on other sites More sharing options...
Grey_Wolf Posted December 28, 2005 Report Share Posted December 28, 2005 SkyD--> as noziimee kaa tas ir zem kaada nosaukuma ..... tur var buut jebkaads nosaukums... ... as ko_piesienies rezultaats buus ieksh $row['ko_piesienies'].... Link to comment Share on other sites More sharing options...
SkyD Posted December 28, 2005 Author Report Share Posted December 28, 2005 (edited) Ok, un veel viens jautaajums! Kāpēc MySQL var iebaazt tikai 255 VARCHAR?? Kaa lai vairaak dabon?!?! Edited December 28, 2005 by SkyD Link to comment Share on other sites More sharing options...
Grey_Wolf Posted December 28, 2005 Report Share Posted December 28, 2005 (edited) SkyD--> tapeec ka tas ir taads datu tips ... taapat kaa ar TinyInt var apziimet skaitli no 1-128 vai ja nav ( - ) tad 256 ------- lielaaku datu glabaashanai ir TinyText , text, Longtext P.S. iesaku palasiit par programmeshanu kaa taadu un par datu tipiem vispaar.... edit: ja nemaldos tad MYSQL vienaa laukaa vareeja iebaaz aptuveni 4Gb informaacijas Edited December 28, 2005 by Grey_Wolf Link to comment Share on other sites More sharing options...
bubu Posted December 28, 2005 Report Share Posted December 28, 2005 (edited) Nevis vienā, bet konkrētā tipa laukā tikai. INT laukā nekādīgi 4GB nesaies. TinyInt var apziimet skaitli no 1-128 vai ja nav ( - ) tad 256 Drīzāk no -128 .. +127. Vai ja unsigned, tad 0..255. Edited December 28, 2005 by bubu Link to comment Share on other sites More sharing options...
SkyD Posted December 29, 2005 Author Report Share Posted December 29, 2005 Ja es gribu ar to TinyText!! Man vinjsh ir janokonfiguree ieksh mysql settingos vai janolaadeE?!?! es te pameklējos, bet atradu tikai visaadus aprakstus pa vinju..!! Link to comment Share on other sites More sharing options...
Grey_Wolf Posted December 29, 2005 Report Share Posted December 29, 2005 (edited) SkyD--> MYSQL manualis !!! un nebuus galiigi kreisi jautaajumi iemaacies saprast kas vispaar ir Datu Bazes un kaa tie dati tiek glabaati P.S. MySQL ir Datu Bazes Vadiibas sisteema kas izmanto SQL 'stuktureeto pieprasijumu valodu' ( ir arii citas DB sisteemas kas izmanto SQL ) edit: sakumaa vari iemaaciities uztaisiit vienkaarshu DB tabulu ieksh MsAccess --> Visam DB pamatprincipi ir vienaadi.. Edited December 29, 2005 by Grey_Wolf Link to comment Share on other sites More sharing options...
SkyD Posted December 29, 2005 Author Report Share Posted December 29, 2005 Varbūt pasaki to kādu citu DB sistēmu, kas izmanto SQL, un uz kura var izveidot vairāk par 255VARCHAR ;DD~ Link to comment Share on other sites More sharing options...
Grey_Wolf Posted December 29, 2005 Report Share Posted December 29, 2005 SkyD--> tu ko esi izliecies vai "----" ? tev tachu saka ka VARCHAR ir datu tips kas paredzeets stringa no 0-255 glabashanai (max 255 simboli) un NEVIENA DB CHAR tips nebuus lielaaks par 255! taapat kaa IP adresee viena lauka lielums ir 255 un ne vairaak !!! Ja vajag vairaak tad glabaa to kaa text vai tinytext vai mediumtext vai longtext ..... kas tev ar 2^32(-1) simboliem nepietiks? kaapeec tu gribi obligaati izmantot VARCHAR ? Link to comment Share on other sites More sharing options...
SkyD Posted December 29, 2005 Author Report Share Posted December 29, 2005 Nee nu ok... Da man joprojaam nedalec par tiem tinytext un longtext..!!! Kas vinji iisti ir??!! Ta nav vienkaarshaak rakstu glabaat, piem kaa raksts_1.txt !!! ... ??!! Bet tur atkal buus ka ar fread, fwrite.. Bet man labpatiktos to dariit ieksh MySQL.. jo pie ta kautkaa esu pieradis..hmm..!! Tas tinytext ir saistiits ar MySQL??!?!! Link to comment Share on other sites More sharing options...
Recommended Posts