help inserting data into mysql

[roach]

howdy
I pieced together a form processing script. I've basically got everything working, except for one thing...now I know it might be ugly, but im just starting to learn PHP =)

The one part of it thats not working right is the db insert. It is inserting each value on a differnt row in the db.

Anyone know what i can change to make this thing insert all the $Name and $Value's on the same row in the db?

Heres the script... thanks!

<?php

global $HTTP_POST_VARS, $HTTP_GET_VARS;

 $Method = (isset($HTTP_POST_VARS)) ? "Post" : "Get";

 $FormVariables = ($Method == "Post") ?
 $HTTP_POST_VARS : 
 $HTTP_GET_VARS;  

 $db = mysql_connect("localhost", "test", "test"); 
 mysql_select_db("test",$db); 

foreach ($FormVariables as $Name=>$Value) {

   echo "$Name : $Value"; 

   $sql = "INSERT INTO table1 ($Name) VALUES ('$Value')";
    $result = mysql_query($sql); 
    }

   exit;

?>

[NiXXeD]

Well, AFAIK, you can't do that unless you know ahead of time what exactly is going to be coming in through the form. Or, you just make a row with a TON of non-specific fields that you can just insert into... But I think it would be in your best interest to just hard code the stuff... Unless you're trying to make a form to process any form?

If not, just do something liek this:

if(isset($_POST["text_submit"])){
    $text1 = $_POST["text1"];
    $text2 = $_POST["text2"];
    //make sure to clean these values too to prevent bad data and such
    //sql stuff
}else{
    echo "<form action='this.php' method='post'>
        <input type='text' name='text1' id='text1' value="">
        <input type='text' name='text2' id='text2' value="">
        <input type='submit' name='text_submit' id='text_submit' value='Submit!'>
        </form>";
}