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)
UPDATE Problem
Moderator: General Moderators
- aceconcepts
- DevNet Resident
- Posts: 1424
- Joined: Mon Feb 06, 2006 11:26 am
- Location: London
Re: UPDATE Problem
Have you tried outputing an error from your query: mysql_error()