Re: Insert problem
| From: | mydata | Date: | Sat, 29 Sep 2001 03:45:37 +0000 |
| Subject: | Re: Insert problem | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-69243@lists.php.net to get a copy of this message | ||
"mydata" <muyuan11@sian.com> wrote in message news:...
> I have seen your code , no error , maybe the error accured in mysql
> database. but mysql_query() will not reflect any error message as I met
> before.
>
> I suggest: Insert code below after mysql_query(),It will show what
happened
> in database.
>
> $result = mysql( YOUR INSERT SQL ) or die(mysql_error());
>
>
> "Martin Kampherbeek" <m.kampherbeek@home.nl> wrote in message
> news:006601c14871$3a1f03e0$328078d9@groni1.gr.nl.home.com...
> > I hope some some can help me.
> >
> > I made a form to put some data in a database.
> > I the form I lmade a security so all fields are filled in.
> > When I submit the form I get the data on my screen, but it will not be
put
> > in the database.
> >
> > To see the form check:
> > http://www.martinkampherbeek.com/test.php
> > To see the code, check the source.
> >
> > At submit, it will start adduser.php
> > The insert line is this:
> > mysql_connect(".....", ".....", ".....");
> > mysql_select_db (...............);
> >
> > mysql_query ("INSERT INTO users (id, username, naam, adres, postcode,
> > woonplaats, telefoonnummer, geboortedatum, emailadres, password)
> > VALUES ('$id', '$username', '$naam',
> > '$adres',
> '$postcode',
> > '$woonplaats', '$telefoonnummer', '$geboortedatum',
> > '$emailadres',
> > '$password')
> > ");
> >
> > I hope someone can tell me why the data will not be put in my database.
> >
> > Cheers,
> > Martin.
> >
> >
> >
>
>