[Resolved] addition in mysql

[keithjasper]

here we go people the ultimate challege ... well for me any way i have no idea even where to start i can build the tables i can add the products from a html page.... heres the scenario...

i add products to a table call baskets including product id, product price, username, timestamp, basket id(AUTOINC, PKEY)

i want to do a "select * from baskets where username = $hvgLogins"

which shows me products in the basket from $username but i want to be able to add up all of the items in $rows[3] together to give me a total price.

how?

simple addition i can do but no idea how i do table/row adding?

sorry to be a pain... thanks😕

[njm]

When you loop through the query results in your PHP script, add a running total:

$total = 0;
while($row = mysql_fetch_array($result))
  {
    $total += $row[3];
    ...
    echo $row[...] //etc
    ...
  }
echo 'Total: '.$total;

hth, njm

[pete_bisby]

You can either perform a simple loop to total up the value:

for ($i=0; $i < mysql_num_rows($res); $i++) {
  $rows = mysql_fetch_row($res);
  $total += $row[3];
}

Or you can write another SQL query:

$qry = "SELECT SUM(product price) AS TotalPrice FROM baskets WHERE username=$hvlogins";

[keithjasper]

there has been a small change to table layout i now have the php script enter price2 (total price for that item) to the database using multiply simple maths.

However i now need to add together all of the values in price2 on the database.? how???

i cant seem to modify either of the code given to make it complete this..

Sorry thanks.

[njm]

Keith,

I'm not sure why the solutions don't work for you.

SELECT SUM(price2) AS total FROM baskets WHERE ...

will sum the price2 column for whatever criterion you want?

hth, njm

[keithjasper]

strange seems to work now... maybe browser didnt refresh..

thanks for the help mjn.