UPDATE Problem

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
tanvirtonu
Forum Commoner
Posts: 35
Joined: Wed Oct 17, 2007 9:15 am

UPDATE Problem

Post by tanvirtonu »

CAN anybody pls tell me where is the problem with the following UPDATE SQL-

UPDATE Month_Rent SET rent_date='4/15/2008', gas ='sd', swearage ='sd', water ='sd', elec_100 ='sd', elec_400 ='sd', elec_service_a-d ='sd', elec_service_e-h ='sd', elec_demand ='sd', elec_vat ='sd' WHERE rent_id='4-2008'

I have 11 fields(including PK) all of which is of VARCHAR type except the rent_date(date type)
User avatar
aceconcepts
DevNet Resident
Posts: 1424
Joined: Mon Feb 06, 2006 11:26 am
Location: London

Re: UPDATE Problem

Post by aceconcepts »

Have you tried outputing an error from your query: mysql_error()
Post Reply