MySQL and PHP where

[Anon]

Hello,

This query fails:

"UPDATE us_soiree
SET n_type_soiree='$n_type_soiree',titre='$titre',n_ville='$id_ville',date='$date',id_lieu='$id_lieu',
n_affinite='$n_affinite',description='$description',theme='$theme',where='$where',who='$who',
hosts='$hosts',age='$age',prix='$price',n_age='$n_age',locked='$locked',nbre_table='$max'
WHERE id_soiree='$id_soiree'"

but if I remove where='$where' it works:

"UPDATE us_soiree
SET n_type_soiree='$n_type_soiree',titre='$titre',n_ville='$id_ville',date='$date',id_lieu='$id_lieu',
n_affinite='$n_affinite',description='$description',theme='$theme',who='$who',
hosts='$hosts',age='$age',prix='$price',n_age='$n_age',locked='$locked',nbre_table='$max'
WHERE id_soiree='$id_soiree'"

It still does not work if I do

"UPDATE us_soiree
SET n_type_soiree='$n_type_soiree',titre='$titre',n_ville='$id_ville',date='$date',id_lieu='$id_lieu',
n_affinite='$n_affinite',description='$description',theme='$theme',where='Town,who='$who',
hosts='$hosts',age='$age',prix='$price',n_age='$n_age',locked='$locked',nbre_table='$max'
WHERE id_soiree='$id_soiree'"

There is definetely a field where in my database. I am wondering if it a problem of keywords likw WHERE. I have to use a field called where.

Any ideas to solve this would be great,

Chris

[slug58]

you cannot use "where" as a column name, change it to "location".

here is a page with the documentation on it:

http://www.mysql.com/doc/R/e/Reserved_words.html

hope this helps,
good luck!!

[Anon]

As far as I can see, if there's no syntax-errors, it can only be that your field "where" is treated as the condition WHERE. So you will need to change the name of the field. I don't see why the name of a field makes any difference, you can call it Pussycat and still put $where in it...n'est pas?

Andre