[RESOLVED] Getting answer to appear in every row

[chrispos]

I have a problem with this script and don't know if I should be using an array. I am trying to get a total adding 2 rows together making a total and then that total showing in every row. The totals are prices in a hotel booking form. I have added $firstprice and $ firstprice1 all the prices work but the problem comes because when i get a total it only adds the first row from $firstprice to every row in $firstprice1. i would like it to add every row in $firstprice to every row in $firstprice1 so that each room has the correct total.

$query = "SELECT * FROM `price`WHERE`month` = 4 AND `year` = 2009";
$result = mysql_query($query) or die (mysql_error());
if (mysql_num_rows($result)>0){ 
while ($row = mysql_fetch_row($result)) {
$pid = $row[0];
$hid1 = $row[1];
$rid1 = $row[2];
$number1 = $row[3];
$rmonth = $row[4];
$ryear = $row[5];
$price1 = $row[6];
$firstprice = $montha * $price1;
echo"$number1\n\n";
echo"$price1<br><br>";
echo "$firstprice<br><br>";
}
}
$query = "SELECT * FROM `price`WHERE`month` = 5 AND `year` = 2009";
$result = mysql_query($query) or die (mysql_error());
if (mysql_num_rows($result)>0){ 
while ($row = mysql_fetch_row($result)) {
$pid = $row[0];
$hid1 = $row[1];
$rid1 = $row[2];
$number1 = $row[3];
$rmonth = $row[4];
$ryear = $row[5];
$price2 = $row[6];
$firstprice1 = $month2 * $price2;
$total = $firstprice + $firstprice1;
echo"$number1\n\n";
echo"$price2<br><br>";
echo "$firstprice1<br><br>";
echo "$total<br><br>";

}
}

The prices are all stored in one table named price
Thanks for your time and help

[Inkeye]

I think I might possibly be misunderstanding your question, but what it sounds like is that you want $total to be a running total of all prices. Yes?

If so, add:

$total = $firstprice;

In between your queries. Then change your second query at the end:

$total += $firstprice1;

Forgive me if I misunderstood the question. If I have, please give an example of the data you want to add together.

[chrispos]

Many thanks for your time but using this just increments one row at a time by the first $total and what I am trying to do is get the correct total for every row by adding the two rows together.

[chrispos]

I'm going to mark this one as resolved because I think I have to try something else as I am not sure the tabel set up will not work but thanks for your help