Select at SQl

[billkirim]

Can anyone help me with that?

i have a table called "tracks"
id title sub_id
1 bill 12
2 bill 17
3 john 12
4 james 12

i want with a sql Statement to make an advanced search with the 2 drop down boxes.

the first has the sub_id=12
the second has the sub_id=17

i want to show me the result "bill".
only id it is in 12(sub_id) AND in 17(sub_id)

[ronverdonk]

You are talking about a combination of server coding (drop down boxes) and MySQL (table selects).

Question to you is: what code (PHP or other server side and MySQL) have you developed so far yourself? And show your code here to us.

Ronald :cool: