Do those field names need single quotes too? Can't remember right now ...
Are there any datatype problems (wrong kind of datatype for a field)?
What about a semi-colon at the end?
Mick
On Thu, 29 Nov 2001, Payzillee wrote:
> 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')")
>
>
>
>
>
>
--
################################
Michael Hall
[EMAIL PROTECTED]
[EMAIL PROTECTED]
http://openlearningcommunity.org
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
