Re: Please help a newbie

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 GR mrfroasty Rij wrote:

Hello, I am new to the world of PHP and MySQL. My objective is to create a table, insert values in it and read it back. Here's the partial code to create a table from a PHP file: if (!$table_exists) {

        $query="CREATE TABLE contacts (id int(20) NOT NULL, name

varchar(15) NOT NULL, address varchar(15),PRIMARY KEY(id)

        if (mysql_query($query, $con)) echo "Table contacts created";
        else die('Unable to create table : '.mysql_error());

} I input the values from a HTML form. Here is the partial code.

        $phone = $_POST['phone'];
        $name  = $_POST['name'];
        $address = $_POST['address'];
        $query = "INSERT INTO contacts VALUES ('$phone', '$name', '$address')";
        if (mysql_query($query, $con)) echo "Values inserted";
        else die('Unable to create table : '.mysql_error());

Now the problem that I am facing is that when I make my first insert, the id field shows a garbage value and not the number that I entered. Subsequent entries into the table show up just fine. It's only the first one. What am I doing wrong? Thanks, Rij

-- Extra details: OSS:Gentoo Linux-2.6.25-r8 profile:x86 Hardware:msi geforce 8600GT asus p5k-se location:/home/muhsin language(s):C/C++,VB,VHDL,bash,PHP,SQL,HTML,CSS Typo:40WPM url:http://mambo-tech.net url:http://blog.mambo-tech.net