Hello,
Your column counts don't match. You call out 24 columns in in your
insert statement, but you only have 20 values.
Curtis
On Tue, 24 Apr 2001, J.Heegsma wrote:
> Dear Sir/Madam and mysql users,
>
> I have a mysql database which i can fill with phpadmin, everything is going fine,
>but when I want to fill the database with php and a form. I got the following
>problem. I don't know what to do anymore? Can anyone help me?
>
> I have made a form, which visitors can fill in, with a php-script I send the
>information to the database. There is a database connection, but the information
>isn't put in the database. When I try to this with phpadmin everything is going fine,
>but with the user form not.
>
> I have put the code under this message, if anyone can help me, I hope to hear from
>him or her by e-mail: [EMAIL PROTECTED]
>
> Thanks,
> Johan
>
> <?
> Require ('connect2.php');
> $sqlquery="INSERT INTO Lid (Achternaam, Voornaam, Adres, Postcode, Woonplaats,
>Telefoonnummer, Emailadres, Geslacht, Geboortedatum, Studentennummer, Hogeschool,
>Opleiding, Studiejaar, Soortlid, Vereniging, Stage, Stageplaats, Stageduur,
>Gratissport1, Gratissport2, Gratissport3, Extrasport1, Extrasport2, Extrasport3)
>VALUES('$Achternaam','$Voornaam','$Adres','$Postcode','$Woonplaats','$Gebdatum','$Soortlid','$Hogeschool','$Collegekaart','$Studierichting','$Studiejaar','$stage','$Stageplaats','$Stageduur','$Keuze1','$Keuze2','$Keuze3','$Keuze4','$Keuze5','$Keuze6')";
> mysql_close();
>
> print "<HTML><TITLE> HBOSPORT Inschrijving </TITLE>
> <BODY BGCOLOR=\"#FFFFFF\"><center><table border=\"0\"width=\"500\"><tr><td>";
> print "<p><font face=\"verdana\" size=\"+0\"> <center>You
> Just send This Information to HBOSPORT<p><blockquote>";
> print "Naam : $Achternaam<p>
> Voornaam : $Voornaam<p>
> Adres :$Adres
> <br>
> Postcode :$Postcode
> <br>
> Woonplaats :$Woonplaats
> <br>
> Gebdatum :$Gebdatum
> <br>
> Soort Lid :$Soortlid
> <br>
> Hogeschool :$Hogeschool
> <br>
> Collegekaart :$Collegekaart
> <br>
> Studierichting :$Studierichting
> <br>
> Studiejaar :$Studiejaar
> <br>
> Stage JA/NEE :$Stage
> <br>
> Stageplaats :$Stageplaats
> <br>
> Stageduur :$Stageduur
> <br>
> <h3>Gratis sport</h3>
> <br>
> <hr>
> Belangstelling voor: :$Keuze1
> <br>
> Belangstelling voor: :$Keuze2
> <br>
> Belangstelling voor: :$Keuze3
> <br>
> <h3>Betaalde sport</h3>
> <br>
> <hr>
> <br>
> Belangstelling voor: :$Keuze4
> <br>
> Belangstelling voor: :$Keuze5
> <br>
> Belangstelling voor: :$Keuze6
> <br>
> </blockquote>
> </td></tr></table>
> </center>
> </BODY>
> </HTML>";
> ?>
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
