I have check boxes with values like - 2610, 1234, 2200MSR, 2200MSTY, MAko, Stack-TA.. etc
Thn have this PDO query in which I am checking this alphanumerical array against family.
Code: Select all
SELECT SUM( IF( STATUS = :status, 1, 0 ) ) passed_count FROM tooldata WHERE family IN ('.$family_implode.') AND startTime >= :date GROUP BY family ORDER BY family' );
Now here when ever I selected any alphanumeric value my query does not work properly. For example .. If I check 2200MSR, I get the data for all the array values having 2200, i.e., 2200MSR, 2200MSTY, Moreover when I select Mako, stack-ta I don't get any output.
How this can be resolved. Please guide.