OScommerce + PHP help

Hello, I need somebody to take care of a few different things for me on my oscommerce site ([login to view URL]). 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 [login to view URL] I would like this done ASAP