Hello - thanks for that but I have already tried this, however here is the new code;
$WADbSearch1->addComparisonFromEdit("show","S_show","AND","=",1);
Still get this when the box is checked with a value of 1;
"You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'show = 1) ORDER BY full_item_details.category_description ASC LIMIT 0, 10' at line 1"
If it helps here is the string from the address bar;
http://localhost/<sitename>/admin/full_item_details_Results.php?S_UID=&S_toyname=&S_show=1&S_category=&S_agerange=&WADbSearch1=Submit&Search.x=43&Search.y=10[/url]
This seems OK to me?
Thanks
Steve