Sedang Disiapkan

Quick and Easy Fixes at 2 Different osCommerce Sites

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

Site 1:

The [url removed, login to view] 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.

Kemahiran: PHP

Lihat lebih lanjut: sql code pdf, problem fixes, my fixes, error fixes, easy problem, discount shopping sites, discount shopping site, coupons discount, budget offer code, oscommerce display product info, sql less, syntax, quick order, php fixes, fixes, fix mysql query, easy fix, easy 2, php sql pdf, sql query format, php sql syntax error, 1064 php, sql different, error query 1064, month budget

Tentang Majikan:
( 72 ulasan ) Gaithersburg, United States

ID Projek: #60206