Page 1 of 1

UPDATE Problem

Posted: Tue Apr 15, 2008 8:23 am
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)

Re: UPDATE Problem

Posted: Wed Apr 16, 2008 4:43 am
by aceconcepts
Have you tried outputing an error from your query: mysql_error()