Need to post from php form to mysql

B-truE

Hi,

I've been trying to setup a form to post to a database for some people who are trying to help with missing persons...

They just need to be able to have a form with 4 fields to post to the corresponding 4 fields in the database.

They have recent versions of php and mysql.

Here are the names in the database:

DB Name: missing
Fields: mtitle, mtext, mperson, minfo

So, the php web form would just have 4 input fields for data to add to the database.

I'd appreciate any existing form that you can direct me to that I can just add the db password and fields etc.

Thank you.

B-truE

More info: I've found a couple form/script example. No matter which one I try, the data is not put into the database from the form. I don't get any db connect errors...

It appears that the form variables are not holding their data for some reason. The form variables match the database fields, so that is correct.

Any ideas?

B-truE

The database only has those 4 fields mentioned above - there is no id field...

So, I'm not sure if my form knows how to post to a new row in the database or not.

Here's the form and script example that I am using:

http://www.help.thinkhost.com/web-development/databases/php-mysql-insert_360.html

I'd sure appreciate some help with this... I've read around here and some of you are very sharp and could get me going in moments.

Thanks in advance...

B-truE

I figured it out. I know many of you know this, but for anyone else that is having troubles with this: versions of PHP from 4.2 on have register_globals set to "off," so variables are not passed. So, you need to make some modifications.

Here's a helpful article/example:

http://www.4webhelp.net/tutorials/php/register_globals.php

B-truE