PHP Help with getting correct amount into table column

[chrisj]

What I'm trying to accomplish, is that every time an amount gets updated to the uploaders 'balance' column,
half that amount gets updated(added to) into the uploaders 'money' column. However, using the code
below, when the amount '3' is added to the 'balance' column, just '1' gets added to the 'money' column,
instead of the intended amount of 1.5. And both columns have the same table structure:

$up_amount = $video_cost_new *0.50;


// add to the balance
$uploader_account = $up_user_start->balance+$up_amount;


$money_amount = $up_amount / 2;
$up_user_start = $db->where('id', $video->user_id)->getOne(T_USERS);
$money_account = $up_user_start->money+$money_amount;
$db->where('id', $video->user_id);
$update_money = $db->update(T_USERS, [
'money' => number_format($money_account, 1, '.', ''), ]);

Can you suggest what I can change to get it correct?

 

[OldMan]

You are only giving us part of the code. What does the table look like?

 

[Ghost]

What I'm trying to accomplish, is that every time an amount gets updated to the uploaders 'balance' column,
half that amount gets updated(added to) into the uploaders 'money' column. However, using the code
below, when the amount '3' is added to the 'balance' column, just '1' gets added to the 'money' column,
instead of the intended amount of 1.5. And both columns have the same table structure:

$up_amount = $video_cost_new *0.50;


// add to the balance
$uploader_account = $up_user_start->balance+$up_amount;


$money_amount = $up_amount / 2;
$up_user_start = $db->where('id', $video->user_id)->getOne(T_USERS);
$money_account = $up_user_start->money+$money_amount;
$db->where('id', $video->user_id);
$update_money = $db->update(T_USERS, [
'money' => number_format($money_account, 1, '.', ''), ]);

Can you suggest what I can change to get it correct?

Is the column in the database an integer column? Does it allow decimals?
Does $db->update treat this money column in the T_USERS table as an integer, or as a double? For example... $db->bind_param("id", $decimal, $decimal); ... this code would turn the first parameter into an integer because the 'i' forces it to, even though the original value is a decimal number. The 'd' on the other hand is a double (floating point number, "float", or any "real number"). It will let you keep the decimal places!