DjNaF Posted March 25, 2006 Share Posted March 25, 2006 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 exampleVisa AND MasterCard AND American Expressand 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 gratefulThank you Quote Link to comment Share on other sites More sharing options...
azuka Posted March 26, 2006 Share Posted March 26, 2006 use "OR" ie:[code]select restid from restcards_tbl where cardid=1 or cardid=2 or cardid=3[/code] Quote Link to comment Share on other sites More sharing options...
DjNaF Posted March 26, 2006 Author Share Posted March 26, 2006 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 aloneI DONT want that! Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.