create database didicratty_main;

use didicratty_main;

create table EmailList (
LastName char(30) not null,
FirstName char(20) not null,
Title char(30),
Email char(25),
Phone char(8),
Address char(40),
City char(25),
State char(2),
Zip char(5),
primary key(Email_ID) )
;

show tables;
show columns from EmailList;

insert into EmailList (
LastName,FirstName,Title,Email,Phone,Address,City,State,Zip)
values ("Cirino","Gary","Designer","gcirino@sbcglobal.net","1284 Riverbed St.","Cleve","OH","44113")
;


select * from EmailList;
grant all on *.* to root@"%";

-----------------------------------------------------------------------------
<?php
// Make a MySQL Connection
mysql_connect("db142c.pair.com", "1016080", "creative") or die(mysql_error());
mysql_select_db("didicratty_main") or die(mysql_error());

// Create a MySQL table in the selected database
mysql_query("CREATE TABLE EmailList(
id INT NOT NULL AUTO_INCREMENT, 
PRIMARY KEY(id),
LastName char(30) not null,
FirstName char(20) not null,
Title char(30),
Email char(25),
Phone char(8),
Address char(40),
City char(25),
State char(2),
Zip char(5),
timestamp )")
or die(mysql_error());  

echo "Table Created!";

?>
-----------------------------------------------------------------------------

<?php
// Make a MySQL Connection
mysql_connect("db142c.pair.com", "1016080", "creative") or die(mysql_error());
mysql_select_db("didicratty_main") or die(mysql_error());

// Insert a row of information into the table "EmailList"
mysql_query("INSERT INTO EmailList 
(LastName,FirstName,Title,Email,Phone,Address,City,State,Zip,timestamp)
VALUES ("Cirino","Gary","Designer","gcirino@sbcglobal.net","1284 Riverbed St.","Cleve","OH","44113",NOW() )
or die(mysql_error());  


echo "Data Inserted!";

?>