Retrieving names from second table from id number
| From: | Brett | Date: | Fri, 16 Mar 2001 23:15:25 +0000 |
| Subject: | Retrieving names from second table from id number | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-7556@lists.php.net to get a copy of this message | ||
I am retrieving values to form a shedule for referees. The master shedule
contains all info for a given date with three referees for that game. The
three referees are refrenced by their id number from the referee information
table. I am now stuck trying to figure out how to take the three referee
id's from the results and display the names and email address for each id.
I am capable of writing a query to return the results from the master
schedule table and the information for each id from the referee info table,
but do not know how to form the query so that where the id would be
displayed I can display the name and email instead. I use mysql and I hope
I explained this in a reasonable way. Any comments suggestions will be much
appreciated.
Brett