Help with this code..please!

[yihungkuo]

I have not touched php for 13 years and I really need a hand to get back in track... First I need help to write up a script as per the condition needed, from there, I'll most likely be able to work on other pages by myself (need a kickstart...).  Please see below conditions:

--------------------------------------------------------------------

some basic info:

------------------------------------

table 1 - coupons_use_history; Entries - $coupons_id,

 

$orders_id, $coupon_use_date, $customers_id

table 2 - orders_total; Entries - $orders_total_id, $orders_id,

 

value, $class

table 3 - customers; Entries - $customers_id, $customers_account

 

----------------------------

condition

-----------------------------

if a certain $coupons_id from table coupons_use_history is

 

present, then list the total cost of each orders ($orders_id):

 

 

1. list total cost per order of that certain $coupon_id.

 

in table orders_total, each $orders_id is referenced to three

 

matching $class in sequence (say orders_id with value 2 is

 

referenced to $orders_total_id entries 4, 5, and 6 and $class

 

ot_subtotal, ot_shipping, and ot_total). The total cost is

 

ot_total = ot_subtotal + ot_shipping.

 

2. list side by side the cost of each order the

 

$customers_account

 

3. list side by side the $coupon_use_date of each order

 

4. all data need to be arranged per months (one month per page

 

or put a box to select which month(s) to be shown.

 

5. need a simple username/password request (single static one per page is ok, no need admin features)

 

-----------------

Any help is very very much appreciated...

 

Another question is about zend... I hired a company to build my website, and this damn company encrytped the whole site with ioncube zend... what's the best way to fix this situation? I can't alter any of it, if I need something modified, I need to call them up to fix it (and they charge further with crappy sloppy coding..i know I was stupid not to make sure the site isn't encrypted before I made the purchase, but it's too late now).  SHould I hire a freelance to copy the website feature exactly?  I also need it to be SEO since that company did a very very sloppy work..  the site is http://www.in-mommy.com if anyone's interested

 

Thanks a million!