DELETE does not work?

Hello, If someone could give me a pointer on this issue: I have a table called codes with only one field left. When trying this in PHP: $result=mysql_query(DELETE FROM codes WHERE left='$temp'); I get a syntax error... This must be some stupid mistake... But I am stuck... Thanks,

Re: DELETE does not work?

At 6:59 PM -0500 11/25/01, Gil G. wrote: Hello, If someone could give me a pointer on this issue: I have a table called codes with only one field left. When trying this in PHP: $result=mysql_query(DELETE FROM codes WHERE left='$temp'); I get a syntax error... A syntax error from PHP or from

RE: DELETE does not work? Fixed!

On 26 Nov 2001 at 0:39, [EMAIL PROTECTED] wrote: Isn't left a reserved word? As in left join? But then, create shouldn't have worked either... Hello, Thanks a lot, that worked! I changed the name of the field, bingo! Sincerely, Gil. PS: for spam filter: database --