Re: Please help a newbie

mrfroasty wrote:

Hello, May be try something like this: $query1= CREATE TABLE contacts( id int(16) NOT NULL auto_increment, phone varchar(15) NOT NULL, name varchar(15) NOT NULL, address varchar(15) NOT NULL, PRIMARY KEY (id) ); $query2 = "INSERT INTO contacts VALUES ('NULL','$phone', '$name', '$address')"; P:S id incremented automatically by MYSQL now

Maybe - but it's by accident. You're trying to insert the word NULL into an int field (it's being treated as a word because of the single quotes around it). Don't specify the id field at all: $query2 = "insert into contacts(phone, name, address) values ('" . mysql_real_escape_string($_POST['phone']) . "', '" . mysql_real_escape_string($_POST['name']) . "', '" . mysql_real_escape_string($_POST['address']) . "')"; You should always use the field names (as above) because if your table gets reordered, your inserts will now break - if you put "name" before phone, the data is now going into the wrong fields. -- Postgresql & php tutorials http://www.designmagick.com/