primary and forgein keys

[zang8027]

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?

 

 

 

[premiso]

select recID, restName, cityID, price, time from clientReceipts cr, restaurants re WHERE cr.restid = re.restid AND  userID = $userID;