having problem in inserting data in mysql data base

Codes here !

Moderators: macek, egami, gesf

seorahulchauhan
New php-forum User
New php-forum User
Posts: 3
Joined: Mon Jul 02, 2012 10:11 pm

having problem in inserting data in mysql data base

Postby seorahulchauhan » Mon Jul 02, 2012 10:23 pm

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

User avatar
egami
php-forum GURU
php-forum GURU
Posts: 2196
Joined: Wed Oct 06, 2010 11:19 am
Location: Happy Valley, UT

Re: having problem in inserting data in mysql data base

Postby egami » Tue Jul 03, 2012 9:18 am

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
New php-forum User
New php-forum User
Posts: 35
Joined: Mon Aug 20, 2012 10:27 pm
Location: Ernakulam
Contact:

Re: having problem in inserting data in mysql data base

Postby Acesystech » Wed Aug 22, 2012 4:29 am

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


Return to “mySQL & php coding”

Who is online

Users browsing this forum: No registered users and 3 guests

cron