I have this slight problem, where I have a list of months with amounts that need to be updated, but I always need to enter "0.0" in order for my field to be updated properly; but if I just enter "0" it doesnt take it and remains empty... ??? I'd like to simply enter 0 and have it update... am I missing a function? my table-field is setup as float(11,2). Here's the basic sql statement I'm using (each month refers to an amount to be updated). Is it beacuse I am NOT filtering the data as integers? or numbers??
$updateQuery = mysql_query("UPDATE BUDGETS SET Jan=$Jan, Feb=$Feb, Mar=$Mar, Apr=$Apr, May=$May, Jun=$Jun, Jul=$Jul, Aug=$Aug, Sep=$Sep, Oct=$Oct, Nov=$Nov, BUDGETS.Dec=$Dec, notes='$notes' WHERE recordid = $accountid AND recordcustid = '$member'");