Our photography company has a database of samples of our photos from jobs. There is a customer table, category table, and a photo table. Inside the photo table there are photo_id, category, customer, event_name, event_date, description, keywords, photo_release fields. In the keywords field we have listed a bunch of keywords separated by comma that deal with that photo. This entry would look like **offshore, magazine, ship, boat, oil rig, platform,tradeshow**. We have a page that is supposed to look up all of these keywords and list them on a page. <[url removed, login to view]>
For some reason it does not get all of the keywords. Look for the word tradeshow in the list…it is not there. Do a search for tradeshow and pictures show up. Look at the pictures that show up and you will see that tradeshow is a listed keyword. The code that pulls the keywords is attached. It also alphabetizes them once loaded into a tmp table. I would like you to get this to work. If you can think of an easier way to get this list of keywords give it a shot. Also Disney & 60s does not show up in the list. There are a few other keywords that are not showing up.
I am looking for someone to fix this script or come up with a better way of listing all of the keywords in alphabetical order.
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):
a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.
b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.
3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).