Re: Query Help Needed
| From: | Michael Hall | Date: | Thu, 29 Nov 2001 21:42:40 +0000 |
| Subject: | Re: Query Help Needed | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-76014@lists.php.net to get a copy of this message | ||
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
admin@openlearningcommunity.org
m.hall@latis.net.au
http://openlearningcommunity.org