0
 829   42   8
  View Articles

Name  
   ±èdz±â  (2005-08-03 12:59:47, Hit : 12738, Vote : 2051)
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 8569 1770
688
  ¿þ¸Þ³ª..¤¾¤¾¤¾¤¾¸»¸Ó¸®¸»ÀÌÁÒ¤¾¤¾ [1]

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

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

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

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

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

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

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

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

±èÁÖ¿Ï
2005/08/03 9400 1960

  php¿¡·¯ [1]

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

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

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

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

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

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

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

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

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

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

Copyright 1999-2025 Zeroboard / skin by Zetyx