WTH Someone to build a PHP script (small / medium)

Discussion in 'Programming' started by lowridertj, Jul 14, 2009.

  1. #1
    Looking to generate a page that will pull data from a 3 tables in my database and display quarterly earnings and fees from those earnings per quarter dating back to when the site opened almost 3 years ago.

    The table structure is good.
    giving transaction numbers, total earned, fees associated with payment, and linux timestamp.

    Tables as they are used
    
    <?php
    
    mysql_query("CREATE TABLE IF NOT EXISTS `paypal` (
      `tranid` varchar(32) NOT NULL default '',
      `amount` varchar(32) NOT NULL default '',
      `fee` varchar(32) NOT NULL default '',
      `user` varchar(32) NOT NULL default '',
      `datebought` int(11) NOT NULL default '0',
      KEY `datebought` (`datebought`)
    ) ENGINE=MyISAM DEFAULT CHARSET=latin1;");
    
    mysql_query("CREATE TABLE IF NOT EXISTS `paypalmini` (
      `tranid` varchar(32) NOT NULL default '',
      `amount` varchar(32) NOT NULL default '',
      `fee` varchar(32) NOT NULL default '',
      `user` varchar(32) NOT NULL default '',
      `datebought` int(11) NOT NULL default '0'
    ) ENGINE=MyISAM DEFAULT CHARSET=latin1;");
    
    mysql_query("CREATE TABLE IF NOT EXISTS `paypalpoker` (
      `tranid` varchar(32) NOT NULL default '',
      `amount` varchar(32) NOT NULL default '',
      `fee` varchar(32) NOT NULL default '',
      `user` varchar(32) NOT NULL default '',
      `datebought` int(11) NOT NULL default '0',
      `postid` bigint(20) NOT NULL default '0',
      KEY `datebought` (`datebought`)
    ) ENGINE=MyISAM DEFAULT CHARSET=latin1;");
    
    ?>
    
    PHP:
    IE: PNL Statement. example attached.


    Will need the spreed sheet attached to be setup that once data is inserted it auto calculates the percentages across the tables.

    Looking to pay on this.
    Please let me know your price for service and how fast you can get this done. Needed immediately.
     

    Attached Files:

    lowridertj, Jul 14, 2009 IP
  2. lowridertj

    lowridertj Well-Known Member

    Messages:
    2,882
    Likes Received:
    40
    Best Answers:
    0
    Trophy Points:
    195
    As Seller:
    100% - 0
    As Buyer:
    100% - 0
    #2
    mods please delete this thread. I have taken care of this thank you.
     
    lowridertj, Jul 14, 2009 IP