0
 829   42   8
  View Articles

Name  
   ±èdz±â  (2005-08-03 12:59:47, Hit : 11322, Vote : 1594)
Subject  
   php¿¡·¯
Column count doesn't match value count at row 1

°­Á¿¡ ÀÖ´Â ¼Ò½ºµéÀ» °¡Áö°í ³ª¸§´ë·Î ÇØº¸·Á°í Çϴµ¥ ÷ºÎÅÍ ÀÌ·± ¿¡·¯°¡ ³ª³×¿ä

±Û ÀÔ·ÂÇÏ°í ¾²±â ¹öưÀ» ´©¸£¸é ÀÌ·± ¿¡·¯°¡ ³³´Ï´Ù...
Âü°í·Î Àú´Â apm_setupÀ» ¾²Áö¾Ê°í mysql°ú php¸¦ Á÷Á¢ ¼³Ä¡Çß½À´Ï´Ù....


µðºñ ¼³°è´Â ´ÙÀ½°ú °°ÀÌ Çß½À´Ï´Ù.

CREATE TABLE bbs
(
number int(10) unsigned  auto_increment not null,
name char(12) not null,
passwd char(16) not null,
email char(50) not null,
homepage char(60) not null,
subject char(60) not null,
memo text not null,
count smallint unsigned not null,
ip char(15) not null,
writetime int not null,
primary key(number),
) ;

¼Õº´¸ñ
À§ ¿À·ù´Â ±âº»ÀûÀ¸·Î Å×À̺íÀÇ Ä®·³ °¹¼ö¿Í SQL ¹®ÀÇ Ä®·³ °¹¼ö°¡ ´Þ¶ó¼­ ¹ß»ýÇÑ ¹®Á¦ÀÔ´Ï´Ù.

Á¦ °­Á ¼Ò½º¸¦ º¸¸é INSERT ¹®Àå¿¡¼­ Ä®·³À» ÁöÁ¤ÇÏÁö ¾Ê°í ¹Ù·Î VALUES ¸¦ ¾²°í ÀÖ½À´Ï´Ù. »ç½Ç ÀÌ·¸°Ô ÇÏ¸é ¿À·ù°¡ ³¯ È®·üÀÌ ³ôÀ¸´Ï±î¿ä, ´ÙÀ½°ú °°ÀÌ Ä®·³ À̸§À» Á¤È®ÇÏ°Ô ½áÁÖ¸é ¿À·ù È®·üÀ» ÁÙÀÏ ¼ö ÀÖ½À´Ï´Ù.

±âÁ¸
$sql = "insert into bbs
values('','$name','$password','$email','$hompage',
'$subject','$memo',$count,'$ip',$writetime)";

¼öÁ¤
$sql = "insert into bbs
(number,name,passwd,email,homepage,subject,memo,count,ip,writetime)
values('','$name','$password','$email','$homepage',
'$subject','$memo',$count,'$ip',$writetime)";

À§¿Í °°ÀÌ Çª¸¥»ö ºÎºÐÀ» Ãß°¡ÇÕ´Ï´Ù. °ýÈ£±îÁö ÇÔ²²¿ä.
±×¸®°í number Ä®·³Àº ÀÚµ¿À¸·Î Ãß°¡Çϴϱî
À§¿¡¼­ Ä®·³ À̸§ number ¿Í VALUES(....) ¾È¿¡¼­ óÀ½ ºóµû¿ÈÇ¥ ('',) ¸¦ »ý·«Çϼŵµ µË´Ï´Ù.

Çѹø ÇØº¸¼¼¿ä~
 2005/08/03 17:21:06    


no
subject
name
date
hit
*
689
  ¾È³çÇϼ¼¿ä [2]

À̵¿½Ä
2005/09/12 7187 1247
688
  ¿þ¸Þ³ª..¤¾¤¾¤¾¤¾¸»¸Ó¸®¸»ÀÌÁÒ¤¾¤¾ [1]

°ø¼±¹Ì
2005/09/07 7666 1357
687
  °­Á¿¡ ÀÖ´Â °Ô½ÃÆÇ ¸¸µé±â¿¡ °üÇÑ Áú¹® [3]

Âù¿í
2005/09/05 7410 1305
686
  php°Ô½ÃÆÇÀ» ¸¸µé´Ù°¡.. [2]

°ø¼±¹Ì
2005/08/31 8319 1356
685
  PHP°Ô½ÃÆÇ Áú¹® [1]

towardz
2005/08/31 7553 1303
684
  À̹ø¿¡ À¥¸¶½ºÅÍ ½ÃÇèÀ» º¸´Âµ¥..^^Á¶±Ý ... [1]

°ø¼±¹Ì
2005/08/18 7387 1300
683
  ºñº£ ¿ÕÃʺ¸Àä [2]

±èÁ¤¹ü
2005/08/18 6951 1270
682
 ºñ¹Ð±ÛÀÔ´Ï´Ù °Ô½ÃÆÇ°ü·Ã.. [1]

ÀÓÀ翵
2005/08/08 3 0
681
  C¾ð¾î Ãʺ¸ÀÚ°¡ º¸±â ÁÁÀº Ã¥ ¹¹°¡ ÀÖÀ»... [2]

À̽Âȯ
2005/08/06 7283 1287
680
  Æû¿¡¼­ ³Ñ°Ü¿Â °ªÀ» µ¥ÀÌÅͺ£À̽º¿¡ ÀúÀå... [2]

±èÁÖ¿Ï
2005/08/03 7804 1438

  php¿¡·¯ [1]

±èdz±â
2005/08/03 11322 1594
678
  ºñº£ °­Á ¼øÂ÷ÆÄÀÏ ¿¡¼­¿ä ^^ [1]

¹è±âÈÆ
2005/07/25 7581 1309
677
  mysql¿¡¼­.. [1]

¹ÚÁ¤È¯
2005/07/15 6987 1310
676
  VB¿Í ¿À¶óŬ »ç¿ëÇÑ ÇÁ·Î±×·¥ ¹èÆ÷ [1]

À±±¤½Ä
2005/05/27 7707 1352
675
 ºñ¹Ð±ÛÀÔ´Ï´Ù php°Ô½ÃÆÇ °ü·Ã Áú¹®Àä .. [1]

ÀÌÁö¾Ö
2005/05/03 5 0
674
  ºñº£¿¡¼­ database »ç¿ë ¹æ¹ý¿¡ °ü... [1]

ÀÓ´ëÇö
2005/04/26 7717 1455
673
  ´ÙÁß¾÷·Îµå¿¡¼­ÀÇ ¼öÁ¤½Ã ÆÄÀÏ»èÁ¦¹®Á¦¿¡... [6]

¼öÁö´Ï
2005/04/18 7154 1197
672
  ¾È³çÇϼ¼¿ä.. ^^ ¿À·£¸¸¿¡ ¿Ô½À´Ï´Ù..... [1]

Çãâ¹Î
2005/04/17 7522 1502
671
  ÀÚ¹Ù½ºÅ©¸³Æ® Áú¹®ÇÒ²²¿ä^^ [2]

ºñ¹Ð
2005/04/01 7213 1352
670
  ´Ù½Ã Çѹø Áú¹®ÀÔ´Ï´Ù.. [1]

Çãâ¹Î
2005/03/14 7766 1566
[1][2][3][4][5][6][7] 8 [9][10]..[42] [next]

Copyright 1999-2021 Zeroboard / skin by Zetyx