Jump to content

Archived

This topic is now archived and is closed to further replies.

DjNaF

where clause problem!

Recommended Posts

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

Share this post


Link to post
Share on other sites
use "OR" ie:
[code]
select restid from restcards_tbl where cardid=1 or cardid=2 or cardid=3[/code]

Share this post


Link to post
Share on other sites
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!

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.