Email Collection to MYSQL

http://www.plus2net.com/php_tutorial/php_signup.php

Its a pretty easy thing to do and a lot of the scripts will be way more than you need. Post back if you want me to do an example.

 

<?php

include('dbconnect.inc.php');
$author = $_POST["author"];
$email = $_POST["email"];
$author=mysql_escape_string($author);
$email=mysql_escape_string($email);
if($email==""){
?>
<form>
Email<input type="text" name="email">
Name<input type="text" name="author">
</form>
<?php
		}
		else
		{
			
	$SQLcommand = "INSERT INTO yourtable";	
	$SQLcommand = "$SQLcommand (name,email) ";
	$SQLcommand = "$SQLcommand VALUES(";
	$SQLcommand = "$SQLcommand '$author','$email') ";
	MYSQL_QUERY($SQLcommand);
	
echo"Thanks";
		}
?>

PHP:

 

The sqlcommands are copied from one of my email collection scripts.
This is the dbconnect file:

$mainconnection =MYSQL_CONNECT("localhost","user","pass") OR DIE("Unable to connect to database");  

@mysql_select_db("yourdbname") or die("Unable to select database");

PHP: