Please help a newbie
| From: | Rij | Date: | Sun, 19 Apr 2009 07:52:10 +0000 |
| Subject: | Please help a newbie | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-46120@lists.php.net to get a copy of this message | ||
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