This is how i do it.
connecting to database.
>$db = mysql_connect(localhost, $db_username, $db_password);
mysql_select_db($db_name);
then to insert
>$sql = "INSERT INTO tablename (value1,value2,value3) VALUES ('$var1','$var2','$var3')";
$result = mysql_query($sql);