[PHP] Query help needed

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,

[PHP] Query Help Needed

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,

Re: [PHP] Query Help Needed

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

AW: [PHP] Query Help Needed

: Payzillee [mailto:[EMAIL PROTECTED]] Gesendet: Donnerstag, 29. November 2001 12:37 An: [EMAIL PROTECTED] Betreff: [PHP] Query Help Needed 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

Re: [PHP] Query Help Needed

I've got my names, web addresses etc. set up as Varchar and my telephone/fax numbers as Bigint. Special interests field as text. Only other field in the database is an auto increment number field. Michael Hall [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... Do

Re: [PHP] Query Help Needed

Could be that the value you're trying to insert doesn't match up with the field type in the database - you know, putting a word in a number field. What exactly is the error message? Payzillee wrote: Hi, could anyone tell me what is wrong with this Insert query? I get an 'Invalid query'

Re: [PHP] Query Help Needed

error message is 'Invalid Query'. Douglas McKenzie [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... Could be that the value you're trying to insert doesn't match up with the field type in the database - you know, putting a word in a number field. What exactly is

AW: [PHP] Query Help Needed

] Betreff: Re: [PHP] Query Help Needed error message is 'Invalid Query'. Douglas McKenzie [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... Could be that the value you're trying to insert doesn't match up with the field type in the database - you know, puttin

Re: [PHP] Query help needed

It looks OK, but I have lousy track record of writing out perfect sql which doesn't work. Syntax looks OK. 1. What does it look like if you write out the update statement, assign it to a var and then echo the var? 2. Can you try it at the console? 3. Try or die(mysql_error) ; to see if you