Freelancer

Description

I manage a bunch of osCommerce sites. Two of them require minor fixes:

Site 1:
The calendar.php file which is being used to manage the site's discount coupon displays the following SQL error message whenever a coupon is not active:

--Error Begins--
1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-5, 5' at line 1

select *, DAYOFMONTH(start_date) AS coupon from coupons_calendar where end_date >= '2006-05-09' and MONTH(end_date) = '05' and language_id = '1' order by start_date limit -5, 5
--Error Ends--

Requirements:
1. Fix the query problem so that the coupon page is blank when all coupons have expired or no coupon is active.
2. Make it possible to have the 1 discount coupon applicable to all the products the site offer (only 5 products). The system currently allows for 1 to 1 relationship but we prefer to have 1 (coupon) to many (products).

Site 2:
The thumbnail images stop displaying in the product listing, product info and shopping cart screens when we FTP'd the images and used txt file format to upload the product information. This problem also affected the PDF datasheet as well.

Requirement:
1. Fix the thumbnail images to display in the following screens:
product listing (or search result display), product info and shopping cart pages.
2. Fix the PDF datasheet code errors.


Budget:
My budget is less than $100

Future Benefit:
On going support and maintenance tasks for those sites that I manage.