display from db

[soda]

i have following value in a db. under note1 there are 3 codes and the total1=code001+code002+code003




note1 - code001,code002,code003
note2 - code004,code005
note3 - code006,code007,code008

how can i get the values from the db and display them as i mentioned below

-------------------------------------------
Note 1 – Title 1
Code 001
Code 002
Code 003
Total 1

Note 2 – Title 2
Code 004
Code 005
Total 2

Note 3 – Title 3
Code 006
Code 007
Code 008
Code 009
Total 3

[Dasher]

what are the names of the columns in your db. What uniquely identifies the data you want to display?

[soda]

my db table structure

code | note | amount

0001 | 1 | 100
0002 | 1 | 500
0003 | 1 | 200
0004 | 1 | 100
0005 | 2 | 1500
0006 | 2 | 1200
0007 | 3 | 1500
0008 | 3 | 1200

[Dasher]

Something like this?

for ($i = 0 ; $i <= 3 ; $i++){

$total = 0;
$query = "SELECT * FROM mydb WHERE note = ". $i ." ORDER BY code ASC"; 
$result = mysql_query ($query);
$q = 1;

while ( $a_row = mysql_fetch_assoc ($result)){
 if ($q==1){echo  $a_row['note'] . "<br>";}
$q++;

echo "Code " . $a_row['code'] . "<br>";
$total = $a_row['amount'] + $total;
}
echo "Total is "  .  $total . "<br>";

} 

[soda]

thanks bro. I'll check it and let you know

[soda]

Thanks a lot Dasher. It works perfect.

[Dasher]

You're welcome.