PROGRAMMER NEEDED TO FIX CODING ERRORS

Hi, I have an e-commerce website already designed and built, but after adding products to the website I have come across some coding errors in the website. This website was built using: Smarty, MySQL, AJAX, JavaScript, Jquery. Okay so basically products are added onto the website via the admin page: [login to view URL] username: admin password: admin. If you go to product management in the admin section you will see that there are a list of different product categories. For each category it will tell you how many products have been added for that category. For example for folded leaflets 164 products have been added. My problem is that, although these products have been added via the admin page successfully, when you actually visit the website and click on that corresponding category, all of those products do not show up. For example if you click: [login to view URL] you will see that only the products up till the first page show up. If you click on the second page, you see that no more products show up, and you get a coding error at the top of the page: " Warning: mysqli_fetch_assoc() expects parameter 1 to be mysqli_result, boolean given in /home/content/s/r/i/srirambachy/html/demo/[login to view URL] on line 24 " There is clearly some error in the coding which is not allowing any of the remaining products to show up. There should be around 62 products for this category, but only 15 or so are showing up on the first page. I think the problem is that somewhere in the codes, it is only permitting the number of products that can be displayed on the first page. Beyond this, no more products will show up. This is a recurring problem for all the categories. For example if you see "Banners" category, the same error comes up when you click on the second page. Also another problem is that when you add products to the website, if the description of the product is not the same length as all the others, the products get fragmented on the page. This can be seen here: [login to view URL] So this too would have to be fixed, so that no matter how the description length varies for each product, no fragmentation occurs. I have already spent a lot of time getting the products added, so ideally I would like all of these errors to be fixed so that all the products can be shown. I do not want everything to be deleted and then added from scratch. Please let me know if you are able to do this job. It is not a simple job, so please only bid if you are an EXPERT programmer. If you think you can please state: "interested2012" in your reply and then I can give you my FTP access, so you can have a look at the website to see if you can fix it. If after seeing the files, and you believe you can fix it then I can award the job to you. After this job I will be needing a full time programmer/designer to maintain my website, so if you are able to successfully complete this job I will have plenty more job opportunities for you. My max budget for this job is $150-$200 Thanks for your interest. Anik