Adding info from file to MYSQL

[nafn]

Hello (:

I'm having trouble trying to say

submitting information on a website, submitting, and then executing it into the mysql database.

My example is, I have a 'country' field in my MYSQL varchar(50).
I want to type in the <input type="text" blah> submit
and want to see that in the database.

How can I do this? thanks

[Krik]

<input type="text" name="country" value="blah">

mysql_query("INSERT INTO `YourTable` (`country`) VALUE ('" . $_POST['country'] . "'");

That is the most basic example. There are other things that you my need to consider. Like if that page is publicly accessible and anyone can submit data you need to take steps to stop injection attacks. Or you may wish to validate that the field is not blank or that they actually entered a country, over them just typing in some irrelevant junk.