Project Detail

Fix SQL Errors in Ecommerse Shop NEED EXPERT PROGRAMMER ONLY  

Fix SQL Errors in Ecommerse Shop NEED EXPERT PROGRAMMER ONLY is project number 280184
posted at GetAFreelancer.com. Click here to post your own project.

 

Bookmark and Share
Free Trial For New Buyers
 

Status: Closed
(Selected Service Provider)

Selected Providers: ranganathp

Budget: $30-250

Created: 06/28/2008 at 0:15 EDT

Bid Count: 1

Average Bid: N/A

06/29/2008 at 0:15 EDT

Project Creator: CG3001 View PM Post PM
Employer Rating: 10.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/10 (18 reviews)

Bid On This Project
 

Description

Have Error code from commerse shop, need it fixed

The Error code is

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 '-20, 20' at line 1

select p.products_id, pd.products_name, p.products_price, s.specials_id, s.specials_new_products_price, s.specials_date_added, s.specials_last_modified, s.expires_date, s.date_status_change, s.status from products p, specials s, products_description pd where p.products_id = pd.products_id and pd.language_id = '1' and p.products_id = s.products_id order by pd.products_name limit -20, 20

[XT SQL Error]

Messages Posted: 0 View project clarification board Post message on project clarification board

Bid On This Project
 
If you are the project creator or one of the bidders Log In for more options
Bids are hidden by the project creator. Log in as the project creator or as one of the bidders to view bids. You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.

    Bid on this Project