[SOLVED] storing email address into table

[bradkenyon]

This is probably extremely easy, but I'll appreciate any help.

I have created a two column table, "id" and "address".

I want to a input box someone can type in their email address, and when they hit the submit button, it will be stored into the table "email_test".

<input type="text" name="address"> <input type="submit">

Now what?

Thanks in advance for reading this.

[ichversuchte]

you first need to connect to the database....

which can look like this

[code]
<?php
    $usr = "username";
    $pwd = "password";
    $db = "database name";
    $host = "localhost";

    $cid = mysql_connect($host,$usr,$pwd);
    mysql_select_db($db);
    if (!$cid) { echo("ERROR: " . mysql_error() . "\n");    }

?>

[/code]

Then need to the form and this code...you might have to tweak it a bit

[code]
<?php
  
    # back on to this page (POST METHOD)
    if ($REQUEST_METHOD=="POST") {
        
        $SQL = " INSERT INTO email_test ";
        $SQL = $SQL . " (address, ) VALUES ";
        $SQL = $SQL . " ('$address') ";
                
        #execute SQL statement
        $result = mysql_db_query($db,"$SQL",$cid);
        
        # check for error
        if (!$result) { echo("ERROR: " . mysql_error() . "\n$SQL\n");    }
        
     echo ("<P><B>Your Request Was Submitted Successfully!!!</B></P>\n");

    }
    mysql_close($cid);
?>
[/code]

should get you started.....