Query Help Needed
| From: | Payzillee | Date: | Thu, 29 Nov 2001 11:37:05 +0000 |
| Subject: | Query Help Needed | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-76007@lists.php.net to get a copy of this message | ||
Hi, could anyone tell me what is wrong with this Insert query? I get an
'Invalid query' error but I can't see the problem at all. All the fields
match exactly what is in my database, it's all in lowercase too.
Cheers.
mysql_query ("INSERT INTO listserve (title, surname, forename, job_title,
org_name, address1, address2, address3, address4, city, region, postal_code,
country, email, mob_phone, tel_number, fax_number, org_web_address,
personal_web_address, special_interests, date, time)
VALUES ('$title', '$surname', '$forename', '$job_title',
'$org_name',
'$address1', '$address2', '$address3', '$address4',
'$city', '$region',
'$postal_code', '$country', '$email', '$mob_phone',
'$tel_number',
'$fax_number', '$org_web_address', '$personal_web_address',
'$special_interests', '$date','$time')")