Results 1 to 3 of 3

Thread: sql

  1. #1
    Join Date
    Sep 2003
    Location
    India
    Posts
    3

    Unanswered: sql

    I am developing a program for a MLM based comapny

    i have the following tables

    1. tbl_member

    membercode,membername,sponsorcode

    2. tbl_sponsor

    sponsorcode,membercode

    3. tbl_level

    levelid,levelname

    4. tbl_bill

    billno,totalbv,membercode,billmonth

    5. tbl_monthlypayouts

    membercode,level,totalbv,comission

    i want to calculate the comission accoring to the toalbv and insert the records in the tbl_monthlypayouts

    levelname totalbv

    3% 1000
    6% 5000
    9% 10000
    12% 20000
    15% 40000
    18% 80000
    21% 100000

  2. #2
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    An MLM? Were there no positions with spammers or telemarketing companies?

  3. #3
    Join Date
    Jul 2002
    Location
    Village, MD
    Posts
    621
    Try to do this by yourself and then post code - may be somebody will have some suggestions or updates.

Posting Permissions

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