RE: [PHP-DB] Variables in MySQL Insert Queries

2001-08-25 Thread Howard Picken
7 PM To: [EMAIL PROTECTED] 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("

RE: [PHP-DB] Variables in MySQL Insert Queries

2001-08-24 Thread KSchneider
ED]] > Sent: Friday, August 24, 2001 12:57 AM > To: [EMAIL PROTECTED] > 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("my

RE: [PHP-DB] Variables in MySQL Insert Queries

2001-08-24 Thread Rick Emery
If this is an exact copy of your script, then you've surrounded each variable name in the VALUES(...) with back-ticks. Why? -Original Message- From: plague [mailto:[EMAIL PROTECTED]] Sent: Friday, August 24, 2001 12:57 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] Variables in MySQL I

[PHP-DB] Variables in MySQL Insert Queries

2001-08-23 Thread plague
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`,'$a