ȸ¿ø°¡ÀԡžÆÀ̵ð/ºñ¹øã±â
ȨÀ¸·Î

[PHP] while($data = mysql fetch array($result)) ¿À·ù ³¯¶§ È®ÀÎ
9³â Àü
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /www/sub2_9.php on line 109

°Ë»ö¸ñ·ÏÀ» º¸¿©ÁÖ´Â ·ÎÁ÷À» ±¸ÇöÇß´Ù. ¼Ò½º´Â Ç×»ó »ç¿ëÇÏ´Â ¸®½ºÆ® Á¦¾îÇÏ´Â ·ÎÁ÷À» ÀÌ¿ëÇߴµ¥ ¿¡·¯°¡ ³­´Ù.


<?php
   $dbconn = mysql_connect("$mysql_host","$mysql_user","$mysql_password") or die("µ¥ÀÌÅͺ£À̽º ¿¬°á¿¡ ½ÇÆÐÇÏ¿´½À´Ï´Ù.");
   mysql_select_db($mysql_db, $dbconn);
   //@mysql_query("set names utf8");   // Çѱ۹®Á¦ »ý±â¸é ÁÖ¼® ÇØÁ¦

  $sql = "select * from hp_courthouse where carea LIKE '%$SearchStr%'"; //order by carea asc
   //echo $sql;
   $result = mysql_query($sql, $dbconn);

   while($data = mysql_fetch_array($result)) {  // ¹®Á¦°¡ ¹ß»ýÇÑ 109 ¶óÀÎ
    //$idx_num = $tot - ($pagemax * ($page_num-1)) - $id_num;
     $carea = $data[carea];
     $chouse1 = $data[chouse1];
     $chouse2 = $data[chouse2];
    echo $carea;
   }
?>

ÀÌ°ÍÀ¸·Î ¸î½Ã°£ ÀÎÅͳݰú ¾¾¸§À» ÇÑ´Ù.
Ȥ½Ã³ª Çؼ­  @mysql_query("set names utf8"); ÀÇ ÁÖ¼®À» Á¦°ÅÇÏ°í È°¼ºÈ­ ½ÃŲ´Ù.
¹®Á¦°¡ ÇØ°áµÇ¾ú´Ù.  ÀÌ·¸°Ô Ç㹫ÇÒ¼ö°¡...
ÃßõÃßõ : 444 Ãßõ ¸ñ·Ï
¹øÈ£ Á¦¸ñ
283
½ÇÇàÁß PHP ¿¡·¯ ¸Þ½ÃÁö ·¹º§ Á¶Á¤Çϱâ
282
PHP - $ SERVER ȯ°æº¯¼ö
281
Example #1 print ¿¹Á¦
280
Á¤±Ô½Ä ¹®¹ý
279
ÇѱÛ, ¿µ¹®, ¼ýÀÚ, Ư¼ö¹®ÀÚ Ã¼Å©ÇÏ´Â ÇÔ¼ö
278
ÀÚÁÖ ¾²ÀÌ´Â Á¤±ÔÇ¥Çö½Ä ¸ðÀ½
277
PHP·Î Internet Explorer ¹öÀü ¾Ë¾Æ³»±â
276
PHP·Î À̹ÌÁö ÁÖ¼Ò ¼û±â±â
275
À¯Åõºê ÁÖ¼Ò¿¡¼­ ¾ÆÀ̵𸸠»Ì¾Æ¿À±â
274
preg_match_all ¸ÆÁÖ¼Ò ÃßÃâ
273
¸ÞŸÅ±׸¦ ÃßÃâÇØÁÖ´Â get_meta_tags ÇÔ¼ö
272
PHP Á¤±Ô½ÄÀ» È°¿ëÇÑ ÅÂ±× ¹× ƯÁ¤ ¹®ÀÚ¿­ Á¦°Å ¹× ÃßÃâ ¹æ¹ý
271
preg_match
270
À̹ÌÁö Å©±â¸¦ ºñÀ²¿¡ ¸Â°Ô Á¶ÀýÇÑ´Ù.
269
°ü°è ¿¬»êÀÚ
268
º´ÇÕ ¿¬»êÀÚ
267
SUBSTR ÇÔ¼ö
266
PHP) Example #1 HTML ¿£Æ¼Æ¼ µðÄÚµù
265
PHP Proxy °¡Á®¿À±â
[PHP] while($data = mysql_fetch_array($result)) ¿À·ù ³¯¶§ È®ÀÎ
263
PHP·Î À̹ÌÁö ÁÖ¼Ò ¼û±â±â
262
PHP Á¤±Ô½ÄÀ» È°¿ëÇÑ ÅÂ±× ¹× ƯÁ¤ ¹®ÀÚ¿­ Á¦°Å ¹× ÃßÃâ ¹æ¹ý
261
php °ø¹éÁ¦°Å ÇÔ¼ö Á¤¸® (¾Õ, µÚ, ¾ÕµÚ, Áß°£)
260
php Å×±×Á¦°Å ÇÔ¼ö¸ðÀ½
259
Ư¼ö¹®ÀÚ ¾ø¾Ö´Â Á¤±ÔÇ¥Çö½Ä
258
ƯÁ¤ ¹®ÀÚ¿­À» ±âÁØÀ¸·Î Áß°£¿¡ ÇÊ¿äÇÑ ¹®ÀÚ¿­ ÃßÃâÇϱâ
257
[php] ÁÖ¼®°ú °ø¹éÀ» Á¦°ÅÇÏ¿© ¹ÝȯÇÏ´Â php_strip_whitespace ÇÔ¼ö
256
for¹® break, continue
255
PHP ÇÔ¼ö¸¦ Javascript ¿¡¼­ »ç¿ëÇϱâ
254
¸µÅ© À̹ÌÁö ÀúÀå ¹æ¹ý (php)
¸ñ·Ï
¹ÂÁ÷Æ®·ÎÆ® ºÎ»ê±¤¿ª½Ã ºÎ»êÁø±¸ °¡¾ßµ¿ ¤Ó °³ÀÎÁ¤º¸Ãë±Þ¹æħ
Copyright ¨Ï musictrot All rights reserved.