WHERE a_id [$i] AND b_id = [$i] result

[Anon]

Hey all,

I'm pulling my hair out. This seemed so simple.

I have a form on page1.php that has 2 arrays built w multiple checkboxes each - I need this form, when posted to page2.php, to select and display from the db where any of the first array conditions are met AND where any of the second are met as well. This is what I have - not working. grimace

SELECT * FROM table_name WHERE a_id = '$checkbox1[$i]' AND b_id = '$checkbox2[$i]'

How do I use the above code to show the selected multiple results?

Thanks in advance...

[tasistro]

should you use an OR instead of an AND in the WHERE clause.

Saludos
Gerardo

[Anon]

Thanks Gerardo,

But that's my problem - BOTH conditions have to be met - the selections from the first array and from the second... The 'or' statement returns results that are not narrow enough - ie: show me all the users who have blond, red or black hair AND who are 20, 25, or 30...

Any thoughts?

[Anon]

Hey, maybe I should look to the left nav here to see Dan LaFlamme's article on checkboxes.

More coffee please. Sorry folks...