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)
);
$que
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'
Ok, figured it out.
I was using an int for the field but the value was too large for it. I
used bigint instead and life is suddenly so much better. Well it helps
that its bright and sunny here too :)
On Sun, Apr 19, 2009 at 10:37 AM, mrfroasty wrote:
> Try using var_export() or var_dump() to debu
Rij wrote:
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))
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')";
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
