Thanks....
Great tip there...
Gr
mrfroasty
Chris wrote:
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.
--
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
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
