I'm having trouble Inserting a variable into a 'money' feild.
i am passing a variable allong called $total.
WHen it comes time to insert into my database, i use
$result = mssql_query(" INSERT INTO $Table_Activity ( SEQN, ID, ACTIVITY_TYPE, Product_code, TRANSACTION_DATE, DESCRIPTION, NOTE, UF_1, UF_2, EFFECTIVE_DATE, THRU_DATE, AMOUNT, ACTION_CODES) VALUES ( '$seqn', '$id', 'ADS', '$newarray[$insertcount], WEB', '$inserttoday', '$category', '$class_city. $class_ad', '$class_city', '$cardtype', '$inserttomorrow', '$insertnextmonth', '$total', '$words')");
when i do that, i get an error because the AMOUNT feild is a Money Type and my variable is not.
My Question is how do i convert my $total variable into something that the money feild will accept. I tried reading up on the CONVERT funtion for SQL, but not getting far wtih it. Is there an easy way to do this?