sPanky Posted December 9, 2008 Report Share Posted December 9, 2008 Sveiki, man jums ir jautājums. Kā var iznest no datubazes ciparu cik reģistrēti lietotāji ? Link to comment Share on other sites More sharing options...
Aleksejs Posted December 9, 2008 Report Share Posted December 9, 2008 SELECT cipars FROM ciparu_tabula WHERE cipars_nozime = 'registreto lietotaju skaits'; Bet nopietni runājot. Ja Tev ir tabula A ar lauku id, tad id skaitu tabulā var uzzināt: SELECT COUNT(id) as SKAITS FROM A Link to comment Share on other sites More sharing options...
codez Posted December 9, 2008 Report Share Posted December 9, 2008 SELECT count(*) FROM users; Link to comment Share on other sites More sharing options...
bubu Posted December 9, 2008 Report Share Posted December 9, 2008 Ja visi reģistrētie lietotāji tiek glabāti vienā tabulā, tad: SELECT COUNT(*) FROM reģistrēto_lietotāju_tabula Link to comment Share on other sites More sharing options...
sPanky Posted December 9, 2008 Author Report Share Posted December 9, 2008 Mēģinu šitā, taču nesanāk <? mysql_query("SELECT COUNT(*) FROM lietotaaji"); ?> Link to comment Share on other sites More sharing options...
bubu Posted December 9, 2008 Report Share Posted December 9, 2008 Iesaku sākt ar šīs lapas izlasīšanu, un galvenais - Example #2 apskatīšanu: http://php.net/mysql_query Link to comment Share on other sites More sharing options...
Aleksejs Posted December 9, 2008 Report Share Posted December 9, 2008 Kā izpaužas "nesanāk"? Link to comment Share on other sites More sharing options...
ddauners Posted December 9, 2008 Report Share Posted December 9, 2008 Mēģinu šitā, taču nesanāk Ja tu raadi kodu - tad radi tadu kads vins tev ir .. Saja gadijuma - neredzu datubazes configuraciju ( kaut ar to pashu include ). Paradi faila saturu no A-Z .. Link to comment Share on other sites More sharing options...
Recommended Posts