Taking info from for and putting it in MySQL

[jayb74]

I am new to PHP and MySQL, so try to bare with me here.

I have create a table in MySQL and I would like to create a form to enter data into this table.

I know that I have to make a mysql_connect. I then created the form, and I know I need to make an SQL quere to insert the data. I just don't know where I have to place the SQL querey. Do I need to put it into the submit button or what?

Also does anyone have any suggestions where I might be able to get scripts from so I can see how things are done? I learn much better that way then from a book or something like that.

[rIkLuNd]

<?php
// This will check that the form has been submitted
if(isset($sent))
{

# connection stuff here...

$sql = "INSERT INTO your_table(value1,value2)";
$sql .= "VALUES('" . $_POST[val1] . "','" . $_POST[val2] . "')";
$result = mysql_query($sql);
if(!$result)
die(mysql_error());

echo "Data has been added!";

mysql_close();

}
else
{
echo "<form action='" . $PHP_SELF . "' method='post'>
<input type='text' name='val1'><br>
<input type='text' name='val2'><p>
<input type='submit' name='sent' value='Send'>";
}

?>