|










|
|
|
 |
0 |
|
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(....) ¾È¿¡¼ óÀ½ ºóµû¿ÈÇ¥ ('',) ¸¦ »ý·«Çϼŵµ µË´Ï´Ù.
Çѹø ÇØº¸¼¼¿ä~ |
|
|

|
|

|
|