www.webdeveloper.com
Results 1 to 7 of 7

Thread: display from db

  1. #1
    Join Date
    May 2008
    Posts
    53

    display from db

    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

  2. #2
    Join Date
    Jan 2006
    Location
    MN
    Posts
    440
    what are the names of the columns in your db. What uniquely identifies the data you want to display?

  3. #3
    Join Date
    May 2008
    Posts
    53
    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

  4. #4
    Join Date
    Jan 2006
    Location
    MN
    Posts
    440
    Something like this?

    PHP Code:
    for ($i $i <= $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>";


    Last edited by Dasher; 07-05-2011 at 05:19 PM.

  5. #5
    Join Date
    May 2008
    Posts
    53
    thanks bro. I'll check it and let you know

  6. #6
    Join Date
    May 2008
    Posts
    53

    resolved

    Thanks a lot Dasher. It works perfect.
    Last edited by soda; 07-07-2011 at 03:12 AM.

  7. #7
    Join Date
    Jan 2006
    Location
    MN
    Posts
    440
    You're welcome.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center



Recent Articles