I have an inventory system I made in a Dreamweaver extension to help in creating databases (WebAssist Data Assist). Attached to this project is a zip file with all of the completed files in it. It basically works, but I need the following fixed:
Please see database/[url removed, login to view] for database structure, if the images portion of the database is incorrect in any way, please fix (or I guess if any of the structure is incorrect, please fix as well). Upload and test on your server, then provide me with the updated files after completion, and I will upload to my server. All items on the pages in red are notes for you, and should be deleted in the final product.
[url removed, login to view]: This is the page where the inventory will be displayed on the main site. What I need for this page to do, is display ALL the inventory in both tables, saddles and accessories. This page and [url removed, login to view] are the only pages that will be displayed on the main site, all other pages belong to the admin section. Neither this page or the inventory_detail page work at all like the admin section does, they are just outlined. On this page, I have outlined how the layout should be for either of the tables, saddles and/or accessories. For the images, The image will be uploaded to the site in the admin section at 400x600 if portrait, and 600x400 if landscape. The thumbnails need to be viewed on the inventory page at 118x177 for portrait and 177x118 for landscape. For the most part, images will be uploaded as jpeg's, but other formats should be able to be used as well (png, gif, jpg at least, but any image format that can be displayed on a page) The title would be the link to go to the detail page ([url removed, login to view]) as well as the "...Learn more" link at the end of the description AND, I would like for the thumbnail image to be linked to the detail page as well. The sort by needs to work as follows: Date Added displays saddles and accessories by the date added from the last added to the first added - Price displays saddles and accessories by the price from lowest to highest - Accessories displays accessories before saddles, sorted by date though, last added to first added - Saddles displays saddles before accessories, sorted by date though, last added to first added. On the thumbnail images, images need to have an alt tag AND a title tag using the saddles_title or accessories_title. The title link needs to have a title tag that matches the saddles_title or accessories_title and the "...Learn more" link in the description should have a title tag of "...Learn more".
[url removed, login to view]: This is the detail page that will be displayed when the title is clicked on for an item in the inventory on inventory.php. I have outlined how an item from the saddles table should be displayed, and how an item from the accessories table should be displayed. This page is pretty straight forward.
admin/[url removed, login to view]: This page is self-explanitory, I just need to make sure it works properly.
admin/[url removed, login to view]: This page is self-explanitory, I just need to make sure it works properly. Displaying the image does not work, it displays the image encoding instead of the image.
admin/[url removed, login to view]: This page is self-explanitory, I just need to make sure it works properly. Just test it on your server. The upload field doesn't really work as it is with the database and needs to be fixed.
... the character limit cut me off WAY too early. Please see [url removed, login to view] in the zip file for full instructions!!! And make sure you actually view the zip file before bidding please! No blind bidding!