zang8027 Posted February 25, 2009 Share Posted February 25, 2009 I need to print out a restaurant name, rather than the ID using keys I got the following mySQL: restaurant table restID Restaurant Name restaurants to city recID restID cityID price time On my page, i want to print out "cicis pizza" rather than "8". So I need a way to do that. Right now, i can connect to my db, run "select * from clientReceipts WHERE userID = $userID;" and that will print out all the restaurant ID numbers. So an example would be this: ID Rest city price date 1 - 8 - 1 - $20.00 - Feb 25 2008 2 - 8 - 1 - $9.99 - Feb 23 2008 3 - 2 - 7 - $10.99 - Mar 2 2009 How can i print out the rest name rather than number using my other table? Quote Link to comment https://forums.phpfreaks.com/topic/146910-primary-and-forgein-keys/ Share on other sites More sharing options...
premiso Posted February 25, 2009 Share Posted February 25, 2009 select recID, restName, cityID, price, time from clientReceipts cr, restaurants re WHERE cr.restid = re.restid AND userID = $userID; Quote Link to comment https://forums.phpfreaks.com/topic/146910-primary-and-forgein-keys/#findComment-771286 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.