Buying Need a Programmer

Discussion in 'Programming' started by pnaidoo, May 7, 2013.

  1. #1
    Hi Guys

    I need a programmer who can help me with a quick script.

    I have a mySQL database with 3 different tables:

    Table 1 (client info), which has an "accountnumber" field.
    Table 2 (statements issued to clients), which has an "account_id" and "amount" fields.
    Table 3 (income received from clients), which also has an "account_id" and "amount" fields.

    I need a script that would display a table with the following information:

    1. A list of all accounts from Table 1
    2. The total sum of all statements issued per account from Table 2
    3. The total sum of all income received per account from Table 3
    4. The outstanding amount per account (the difference between the sum of Table 2 and Table 3)

    Please let me know if you can do this script and what you will charge me.

    Thanks
     
    pnaidoo, May 7, 2013 IP
  2. ceosomeday

    ceosomeday Peon

    Messages:
    7
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    1
    As Seller:
    100% - 0
    As Buyer:
    100% - 0
    #2
    I can do it in perl
     
    ceosomeday, May 8, 2013 IP
  3. kas5986

    kas5986 Greenhorn

    Messages:
    2
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    21
    As Seller:
    100% - 0
    As Buyer:
    100% - 0
    #3
    I can do it please let me know :)
    my portfolio www kas5986.elance.com
     
    kas5986, May 8, 2013 IP
  4. join4m

    join4m Member

    Messages:
    59
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    43
    As Seller:
    100% - 0
    As Buyer:
    100% - 0
    #4
    i can do this please pm me
     
    join4m, May 9, 2013 IP
  5. ankit_frenz

    ankit_frenz Active Member

    Messages:
    1,111
    Likes Received:
    41
    Best Answers:
    0
    Trophy Points:
    63
    As Seller:
    100% - 0
    As Buyer:
    100% - 0
    #5
    I haven't been to this forum in quite some time , so hope this is still the way we are supposed to bid :)
    Will cost you 75$ given within 24 hours written in PHP. Please PM me if interested.
     
    ankit_frenz, May 10, 2013 IP
  6. CodeBeast

    CodeBeast Well-Known Member

    Messages:
    463
    Likes Received:
    8
    Best Answers:
    0
    Trophy Points:
    155
    As Seller:
    100% - 0
    As Buyer:
    50.0% - 1
    #6
    Can be done as a desktop or web based application. Just PM me if the spot is still available.
    It should be done within 24 hours.
     
    CodeBeast, May 11, 2013 IP
  7. WindelSolutions

    WindelSolutions Well-Known Member

    Messages:
    253
    Likes Received:
    3
    Best Answers:
    0
    Trophy Points:
    115
    As Seller:
    100% - 0
    As Buyer:
    100% - 0
    #7
    If this is still available, let us know. We can do this for you.
     
    WindelSolutions, May 11, 2013 IP