having problem in inserting data in mysql data base

[seorahulchauhan]

I am trying to creating a registration form using php but having a error
====================================
Error inserting data to the table
query:insert into fgusers3(
name,
email,
username,
password,
confirmcode
)
values
(
"Rahul Chauhan",
"seorahulchauhan@gmail.com",
"seorahulchauhan",
"57c4daa88c70b8f741e2509f1647ccd4",
"3349d32f3f5561a354750b47c02569ee"
)
mysqlerror:Unknown column 'confirmcode' in 'field list'
Inserting to Database failed!
========================================

cane any one tell me how to solve this problem

[egami]

do this..


$query = "SHOW COLUMNS FROM $table";
$result = mysql_query($query);
while ($row = mysql_fetch_assoc($result)) {
echo '<pre>'; print_r($row); echo '</pre>';
}

Then make sure that the field exists... and then make sure that the cAsE is CoRrEcT.

[Acesystech]

I think confirmcode field not found in Database....