Search Error - Column 'ss_LineParentID' in where clause is ambiguous
On my clothing results page, I have a search form with 3 dropdown select menus and 1 plain input field.
Search by: Line
Search by: Category
Search by: Sub-Category
Search by: Name
I get errors when searching from any of the top 2 dropdown select menus:
Column 'ss_LineParentID' in where clause is ambiguous
Column 'ss_CatParentID' in where clause is ambiguous
When searching only by "sub-category" dropdown select menu, this works fine, as well as the name search.
I have attached the results page and screenshot of relavent clothing db tables.
Thanks in advance.