UPDATE syntax problem

[ratso]

Hi,

I am having a problem with this query for UPDATEing my database

$sqlquery = "UPDATE '$table' WHERE client_id='$client_id' SET name='$name' street='$street' city='$city'county='$county' postcode='$postcode' phone='$phone' fax='$fax' email='$email' website='$website'c_council='$c_council' d_council='$d_council' stat_dev='$stat_dev' trad_act='$trad_act' org_type='$org_type' enq_sourc='$enq_sourc' init_contact_date='$init_contact_date'legal_struct='$legal_struct' keywords='$keywords' null_field='$null_field' descr='$descr' gender='$gender'";

I have tried it with commas after each string but still no avail. The variables are being posted to the page as I can print them.

Any wizend advice floating about?

Thanks in Advance

Ratso

[blindlizard]

try this:
$sqlquery = "UPDATE $table SET name=\'$name\', street=\'$street\', city=\'$city\', county=\'$county\', postcode=\'$postcode\', phone=\'$phone\', fax=\'$fax\', email=\'$email\', website=\'$website\', c_council=\'$c_council\', d_council=\'$d_council\', stat_dev=\'$stat_dev\', trad_act=\'$trad_act\', org_type=\'$org_type\', enq_sourc=\'$enq_sourc\', init_contact_date=\'$init_contact_date\', legal_struct
=\'$legal_struct\', keywords=\'$keywords\', null_field=\'$null_field\', descr=\'$descr\', gender=\'$gender\' WHERE client_id=\'$client_id\'";

[steved]

Try this:

$sqlquery = "UPDATE $table SET name='$name', street='$street', city='$city', county='$county', postcode='$postcode', phone='$phone', fax='$fax', email='$email', website='$website', c_council='$c_council', d_council='$d_council', stat_dev='$stat_dev', trad_act='$trad_act', org_type='$org_type', enq_sourc='$enq_sourc', init_contact_date='$init_contact_date', legal_struct='$legal_struct', keywords='$keywords', null_field='$null_field', descr='$descr', gender='$gender' WHERE client_id='$client_id' ";

Removed quotes from around table name, added commas, moved where clause to end of sql.

[steved]

You may also need to remove the quotes from around your $client_id variable.

[ratso]

mmm, neither of them worked, it must be something else thats causing the problem, thanks for the assistance though guys, appreciate it

Ratso

[blindlizard]

what error are you getting? Also, echo out the sql string and make sure it looks right.

[ratso]

Success!!

It was trying to update fields in the query that didnt exist anymore, I changed their names in the table but forgot the change it in the query.

Serves me right for copying and modifying old databases for new projects instead creating new ones

Thanks again for the help

Ratso

[blindlizard]

It is usually the simple obvious answers we over look 🙂