Prayer !! Posted June 19, 2008 Report Share Posted June 19, 2008 Sveiki! griežos ar savu jautajumu pie jums, jo pats netieku gala un draugam iedevu apskatīties sho skritpu vinjs ar nezin ka spa vainu.. ļoti ceru uz jūsu palīdzību.. :) Iemetu klat ari erroru.. Piekonektejas db pareizi, to jau aprbaudiju bet kaut kas skripta naw pareizi ludzu dodiet kaut vai majienu :) Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /usr/home/Prayer/xxx/xxxxxx/update_web.php on line 5 Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /usr/home/Prayer/xxx/xxxxxx/update_user.php on line 5 Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /usr/home/Prayer/xxx/xxxxxx/update_page.php on line 5 Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /usr/home/Prayer/xxx/xxxxxx/update_card.php on line 5 Zemāk ir linki uz skriptu, visiem failiem.. :) http://paste.php.lv/7543 http://paste.php.lv/7544 http://paste.php.lv/7545 http://paste.php.lv/7546 http://paste.php.lv/7547 http://paste.php.lv/7548 Link to comment Share on other sites More sharing options...
codez Posted June 19, 2008 Report Share Posted June 19, 2008 mysql_query("SELECT * FROM table") or die("error " . mysql_error()); pieliec pēc kverija or die(), lai redzētu kur ir kļuda, jo kļūda ir SQL izteiksmē. Link to comment Share on other sites More sharing options...
Prayer !! Posted June 19, 2008 Author Report Share Posted June 19, 2008 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 's Little Helper'' at line 1 Izskaidrojiet šo erroru nekad naw gadijies sastapt un neko daudz no viņa nesaprotu.. mysql manual ar skatijos neatradu aks tur ir domāts :D:D:D Link to comment Share on other sites More sharing options...
codez Posted June 19, 2008 Report Share Posted June 19, 2008 (edited) tev php mainīgais satur ' simbolu tekstā "kautka's Little Helper", šis simbols sabojā tavu kveriju, tāpec visus datus, pirms liec iekšā kverijā, apstrādā ar šo funkciju: http://lv.php.net/function.mysql-real-escape-string Edited June 19, 2008 by codez Link to comment Share on other sites More sharing options...
Ghenis Posted June 19, 2008 Report Share Posted June 19, 2008 mysql_query rezultātu der pārbaudīt pirms turpmākas izmantošanas, jo funkcija mysql_query kļūdaina vaicājuma gadījumā klusi atgriež false. Link to comment Share on other sites More sharing options...
Grey_Wolf Posted June 20, 2008 Report Share Posted June 20, 2008 Izskaidrojiet šo erroru nekad naw gadijies sastapt un neko daudz no viņa nesaprotu.. Pietiek jau ar pirmo errora dalju --> nepareiza kverija Sintakse ... Par so temu ir runaats 1001 reizi ..... ir taada lieta kaa Debugosana --> pieliec elementaru echo lai izvadiitu kveriju uz ekrana --> pats redzesi kur ir kljuda ..... Link to comment Share on other sites More sharing options...
Prayer !! Posted June 20, 2008 Author Report Share Posted June 20, 2008 Hmm liels paldies, tgd erroru par to naw, bet ir tada lieta, ka tgd skripts man shkiet, ka neloopojas.. Vinjs iziet cauri visam vienu reizi un apstājas.. Ir kādi ieteikumi? Link to comment Share on other sites More sharing options...
bubu Posted June 20, 2008 Report Share Posted June 20, 2008 Ir ieteikums - sāc debugot. Link to comment Share on other sites More sharing options...
Prayer !! Posted June 20, 2008 Author Report Share Posted June 20, 2008 viss kartiba tgd :) paldies Link to comment Share on other sites More sharing options...
n0r3k Posted June 26, 2008 Report Share Posted June 26, 2008 sintaxe nepareiza. if(!mysql_fetch_array($player_take) == 0) varbūt domāji ? if(mysql_fetch_array($player_take) != 0) pareizāk būtu rakstīt if(mysql_num_rows($player_take) > 0) Link to comment Share on other sites More sharing options...
Paulinjsh Posted June 26, 2008 Report Share Posted June 26, 2008 n0r3k a kāpēc tad nedrīkstētu tā rakstīt kā uzrakstījis? nav pareizi, nepareizi - ir ieteicams un neieteicams stils. Link to comment Share on other sites More sharing options...
Recommended Posts