PHP - MySQL Help Request

[StarsNGuns]

Greetings all. First post here so please bare with me as I test the waters out and try not to upset the locals too much.

I recently built a Flash MX 2004 form in which all entered data (four fields) kicks out to a php file which gathers the info and then e-mails me the entered data. You can see how all the e-mails will quickly get annoying so my thought was to kick these four fields out to MySQL and have them store in their own respective columns. problem is, my attempts at accomplishing this have been unsuccessful.

If anyone could offer any advice I would be most appreciative. In case you need them, the fields I am kicking out of Flash are $Name, $senderemail, $address, $answer. thanks in advance for any help that is offered.

[rgermain]

What have you got done concerning the MySQL Database/Table?
Is it setup or anything?
Or is that what you need help with?

Let us know and we can try and help! 🙂

[StarsNGuns]

Thanks for the quick reply!

Well I did create the database and tables but after it failed to log the data I deleted it all in frustration. LOL! Ever had one of those days? 😃 I was not sure if my PHP script was incorrect or if I had my database set up wrong so I figured the best thing for me to do is find someone to walk me through this one time so I don't kep screwing things up.

[rachel2004]

You'll need to set-up your db/tables/columns again before any code is written, as you know. Once you do that, you should try INSERTing a record from just the MySQL monitor. It would like:

mysql > INSERT into Table (col1, col2, col3) VALUES ('value1', 'value2', 'value3');

If you can get that operational, then it's just a matter of putting that into a PHP script. See if you can get tables created again plus run the INSERT statement I gave you. Then post back and we can work on the code or I can point you to an online tutorial which may be better if you are doing this for the first time.

[StarsNGuns]

I was able to create the table I needed and had a successful run with the insert statement. Thanks! Now the PHP code. This is what I came up with but unfortunately nothing works. Any help would be appreciated.

<?php

$dbms = 'mysql';

$dbhost = 'hostname';
$dbname = 'name';
$dbuser = 'user';
$dbpasswd = 'password';

$query = "Insert Into table (col, col, col)
Values ('value1', 'value2', 'value3')";

?>

That's all I have! But apparently it isn't right.

[rachel2004]

Somewhere earlier in your code, have you already selected your database using the mysql_select_db() function? Also, did you use the function mysql_connect() or mysql_pconnect() to contain all of your db connection settings?

If this is news to you, the PHP manual can give you some snippets of correct usage:

www.php.net/mysql_select_db
www.php.net/mysql_connect

To run the query:

www.php.net/mysql_query

By the way, is $dbms the variable containing the database that you wish to connect to? If yes, you should connect to something other than the "mysql" database that is created when you install MySQL. Just to be on the safe side.

Lastly, your query is almost correct. When you name specify your columns, they cannot all contain the same name. I don't know if you did that intentionally or unintentionally. Look at my previous post and notice how I distinguished one column name from the other.

[StarsNGuns]

THAT WAS IT!!! I forgot to select and connect my database. It is all working the way it should be now and I cannot thank you enough. I feel comforted knowing that there are knowledgable people like you to help me through this learning process. I hope you will assist me in the future, because I know I will need it. Thanks again!

[rachel2004]

Originally posted by StarsNGuns
THAT WAS IT!!!

You're welcome. Thanks for making my day. 😉