Here is the SQL. I normally add this to my search pages and leave it there, a tip I picked up from you awhile back.
SQL: SELECT Line_Id, Line_Name, Line_Nickname, Start_Decade, End_Decade, Manufacturer, Size, Cat_1, Cat_2, Cat_3, Approved, Locked, Added_By, Line_Text FROM figure_lines WHERE (Approved = 0) AND (Locked = 0) ORDER BY Line_Name ASC LIMIT 0, 10
I know the WHERE statement is saying "= 0" but I don't see where that is happening. Maybe I am thinking about this wrong but I though by having the checked value = Y on the search page that it would send that value in the URL. So I'm guessing the issue is on the Results page?
Thanks.