RE: [PHP-DB] Variables in MySQL Insert Queries
| From: | Howard Picken | Date: | Sat, 25 Aug 2001 08:29:41 +0000 |
| Subject: | RE: [PHP-DB] Variables in MySQL Insert Queries | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-11823@lists.php.net to get a copy of this message | ||
You've created the query but haven't actually run the query.
i.e.
$result = mysql_query($sql);
I'm new to this but I think that's what you're problem is.
Howard
-----Original Message-----
From: plague [mailto:plague@freeze.com]
Sent: Friday, 24 August 2001 3:57 PM
To: php-db@lists.php.net
Subject: [PHP-DB] Variables in MySQL Insert Queries
I am using this code to connect to my database and insert form data from a
user:
$connect = mysql_connect("myhost","user","pass") or die (" not
connected");
@mysql_select_db("dbname");
$sql="INSERT INTO tablename
(id,first,last,age,email,sfuser,sfship,icq,ac,loca,ref)
Values(,
$first,$last,'$age',$email,$sfuser,$sfship,$icq,$ac,`$
loca,$ref`)";
echo (mysql_affected_rows()?"success":"failure");
mysql_close($connect);
The script returns "success" except for it doesn't insert the data ( from a
form ).
The age column is BLOB, not INT.
I would really appreciate the help of someone, as this has really stumped
me.
Thanks,
plague