Heeellllppp!!!! Problem with INSERT INTO

[marieloona]

Hi!

Am having a problem with inserting my data into my database. I am trying to use the "INSERT INTO db_name (columns etc.) VALUES ($variable1etc)".

The variables I am using come from a form, and I have given each text area etc. a name which I am using as my variable. I just can`t get the stuff into the database. Do you know if I have to use al the column names and insert something into each one of them, or can I just insert into a couple of them, as long as I have them down in the right order?

Please help me, as I am getting desperate and have been sat in front of my PC for hours and am now in total and utter despair.

[rIkLuNd]

What is the error? Doesn't anything get inserted, or what? What variables are your using?

If your server has register_globals off, then you'll have to use the $_GET and $POST variables...

[kaos057]

There could be numerous reasons why it isnt working. I would suggest pasting all of your form and action code so we can actually see what could be wrong rather than just knowing what your problem is. It could very easily be your submit button, incorrect form settings, or maybe the form just isnt getting to the actual query part. Post your whole code and I'm sure it will get resolved very quick.

[BloodyBoy]

I bet rIkLuNd is right 😉 I had this problem too, not too long ago hehe 😃

just look for your php.ini, and change

register_globals=off

to

register_globals=on

this can be a little security breach, but why care? for newbies (like me ) it's easier this way 🆒