954,591 Members — Technology Publication meets Social Media
Username:
Password:
Lost login information?
Have something to say? Contribute New Article Reply to this Article

php wont submit data into the database



";

echo "


You Just Entered This Information Into the Database



";
//display the information that user submitted in the previous form
echo "


Name : $name


E-Mail : $email


Sex : $sex


Birthdate: $month / $day / $year







Killer_Typo
Master Poster
781 posts since Apr 2004
Reputation Points: 152
Solved Threads: 39
 

$results = mysql_query($sqlquer y); //Query the results

if(!$results){
echo(mysql_error());
}

Arizona Web
Junior Poster
118 posts since Jun 2004
Reputation Points: 16
Solved Threads: 2
 
$results = mysql_query($sqlquer y); //Query the results if(!$results){ echo(mysql_error()); }

thank you thank you thank you.

here are the results.

Column count doesn't match value count at row 1

(heres a screenshot of what the database looks like)thank you thank you thank you.

here are the results.

Column count doesn't match value count at row 1

(heres a screenshot of what the database looks like)srry for the double post, but i figured it out, i had accidently included $email twice, once removing the second $email it all worked out. thanks arizona web for the help, i wouldnt have thought to double check that if i hadnt seen the error that i got.

Attachments database_picture.JPG 71.4KB
Killer_Typo
Master Poster
781 posts since Apr 2004
Reputation Points: 152
Solved Threads: 39
 

NP bud. While I am developing I always echo errors after every SQL statement in PHP and keep debug on in other languages. Makes it easier to know off the bat where the problems are.

Arizona Web
Junior Poster
118 posts since Jun 2004
Reputation Points: 16
Solved Threads: 2
 
srry for the double post, but i figured it out, i had accidently included $email twice, once removing the second $email it all worked out. thanks arizona web for the help, i wouldnt have thought to double check that if i hadnt seen the error that i got.

Glad you were able to figure it out, but please use the "edit" button to modify your post. It doesn't take very long. It's the second time, that I know of, that you double post. I don't want to be a bit**, but obey the rules.

samaru
a.k.a inscissor
Team Colleague
1,256 posts since Feb 2002
Reputation Points: 262
Solved Threads: 18
 

This article has been dead for over three months

Post: Markdown Syntax: Formatting Help
You