Hello, I need somebody to take care of a few different things for me on my oscommerce site ([url removed, login to view]). Here is what I need done:
1) My SQL syntax broke somehow and I can't utilize my search functions. I get 2 different errors. When using my search button, I get error 1064 no matter what search criteria I enter. You can view this pretty easily on the site. The other error occurs when at my homepage I select a manufacturer. I select Citizen (for instance) and it brings returns all Citizen watches. If I then narrow it down by selecting Show: any category (this is at the top of the page) it returns error 1109 saying "unknown table 'p.products_id'. I need both of these errors fixed.
2) I want 1 php page to show the top selling mens watches, and a different php page to show the top selling womens watches. This should display 20 watches based on their rank in sales.
3) I want the "purchase without account contribution installed"
4) I want the add to cart button to be added at the top of each product description right underneath my "In stock now/ out of stock" indicator. Here is an example page [url removed, login to view]
I would like this done ASAP