getting total of 2 values seperated by space

nicky77uk1

Hello All,

i have a DB and which has a field called rates.

in rates i have 2 values stored by using a space in between. i.e 45 65

i just need to TOTAL the 2 values in the field, when i PHP a total i only get the 45, it does not read the space and misses the 65. i need to be able to total them both and get 110.

any ideas?

Weedpacket

Not without seeing the code you're using (unless array_sum(explode(' ', $field)) counts).

nicky77uk1

$sql ="select rates from room";
$res=@mysql_query($sql);
while ($r= mysql_fetch_assoc($res)) {
print_r($r);
	$rs=$r['rates'];
echo"$rs<BR><BR>";

}

this is what i get on my screen:

Array ( [rates] => 65 49 ) 65 49

Array ( [rates] => 58 29 58 29 58 ) 58 29 58 29 58

i need to know how to total each line to give me 114 for the first row and 232 for the 2nd.

i played around with the explode idea but didnt get anywhere...
please help! cheers!

Weedpacket

Well, first of all, that's a dumb way of storing the rates. You've got a database - it's capable of giving you the SUM() of a set of results if you store the data in it properly.

And array_sum(explode(' ', $rs)) works for me. But I am assuming you really only do have exactly one space character separating the rates. If it could be something else then you'd have to take that into account (something else you wouldn't have to do if you fixed your database).