Hello!
I'm trying to update our search process so it works a little better. Currently, it's set up so it looks at the tables with the item's name, number, color, and description. For whatever reason, it didn't work very well that way and it was leaving out a lot of results that should have been included. So, to remedy this, I added 2 new tables: pro_item_keyword and pro_item_keyword_look_up. The keyword table has a Keyword and Keyword_ID. The look up table has an ID and a Keyword_ID. I followed the same setup as the other selects and joins in the file (that had been working decently well) when adding the keyword parts. As soon as I added the lines for the keyword tables and did a search, it told me the number of items that fit what I was searching for, but didn't actually display any of them. I had based it off of the lines dealing with the color mostly, since the color isn't actually displayed on the results page (and the keyword wouldn't be either). I know that the MySQL tables are connecting to the keywords tables because of the additional number of results. I don't understand why it works fine until I add additional tables into the mix. Should the table settings be something specific that I might have missed? Or did I goof up the coding? Any help would be awesome! Thank you in advance! 
My apologies, the full code wouldn't fit, so I've attached a .txt of the file.[ATTACH]5141[/ATTACH]
results.txt