where clause problem!

[DjNaF]

hello;

i have this table (restcards_tbl) ,
[b]both are primary keys[/b]
+--------+--------+
| restid | cardid |
+--------+--------+
| 1 | 1 |
| 1 | 2 |
| 1 | 4 |
| 1 | 6 |
| 15 | 1 |
| 15 | 2 |
| 15 | 3 |
| 15 | 4 |
| 15 | 12 |
+--------+--------+

and this table (cards_tbl)

+--------+------------------+
| CardID | CardName |
+--------+------------------+
| 1 | Visa |
| 2 | Master Card |
| 3 | American Express |
| 4 | GO Card |
| 5 | Golden Card |
| 6 | Green Card |
| 7 | Silver Card |
| 12 | Bronze Card |
+--------+------------------+

every restaurant have an id RESTID.
and CARDID means , the id of the cards accepted in the restaurants.

i want a coide that the user can search for the restaurants that accepts for example
Visa AND MasterCard AND American Express

and it displayes the id for those restaurants!

i tried
[code]select restid from restcards_tbl where cardid=1 and cardid=2 and cardid=3[/code]

but no results :(
if any1 has a php code to help me display results i'd be grateful

Thank you

[azuka]

use "OR" ie:
[code]
select restid from restcards_tbl where cardid=1 or cardid=2 or cardid=3[/code]

[DjNaF]

I want the resdtaurant that has 1 AND 2 AND 3 together!
OR will list all restaurants that have 1 alone and 2 alone, and 3 alone
I DONT want that!