sviesc Posted February 12, 2004 Report Share Posted February 12, 2004 man būt proba ar tiem mysql pieprasijumiem esmu izmēģinajis sazin ko mans nesaprast kape nestrādā tas GROUP BY un kapē man nesanākt joks ar to DISTINCT ko es tur būt saraxtijis nepareizi jau iepriekš atvainojos tu i dafiga mainīgi kuri netiek tā kartīgi izmantoti bet es to scriptu tikai raxtu kods te http://paste.php.lv/748 Link to comment Share on other sites More sharing options...
рпр Posted February 12, 2004 Report Share Posted February 12, 2004 $ip = mysql_query("SELECT ip FROM $usertable GROUP BY ip"); ja tu domaa shito rindu, tad manupraat taa ir vispaar lieka, jo shis pieprasiijums peec tam nekur netiek izmantots. uz vindowsa raksti tos skriptus? kapeec tu pirms liec iekshaa skriptaa tos qverijus nepatestee caur mysql klientu? Link to comment Share on other sites More sharing options...
sviesc Posted February 12, 2004 Author Report Share Posted February 12, 2004 es strādāju pie linuxa un tur i tā proba neesmu atradis nevienu jēdzīgu mysql klientu Link to comment Share on other sites More sharing options...
Kaklz Posted February 12, 2004 Report Share Posted February 12, 2004 es strādāju pie linuxa un tur i tā proba neesmu atradis nevienu jēdzīgu mysql klientu kā ir ar MySQL Control Center? Link to comment Share on other sites More sharing options...
Gacha Posted February 12, 2004 Report Share Posted February 12, 2004 Vot jaa! MySQL Control Center ir baigi labs, jo taa ir programma, nevis kā phpmyadmin kurš ir webā. Link to comment Share on other sites More sharing options...
sorehead Posted February 12, 2004 Report Share Posted February 12, 2004 nu jaa, tev vaicaajumi ir skersaam uzrakstiiti. piemeram sitais: "SELECT FROM ip, COUNT(*) AS skaits FROM $usertable GROUP BY ip ORDER BY skaits DESC" sajaa gadiijumaa lieks FROM. paarbaudi, paareejos, es tikai taa - aci uzmetu. Link to comment Share on other sites More sharing options...
Kikko Posted February 12, 2004 Report Share Posted February 12, 2004 Iespējams ka problēmas rodas dēļ nepareiza datuma formāta: $date_today = date ("Y.m.d"); MySQL native formāts ir "YYYY-MM-DD" (separātors nav punkts bet mīnuss). Link to comment Share on other sites More sharing options...
sviesc Posted February 13, 2004 Author Report Share Posted February 13, 2004 ar datumu tam nav nekāda sakara ar to datumu vis i ok Link to comment Share on other sites More sharing options...
Recommended Posts