Table Relationships
| From: | David Smith | Date: | Fri, 06 Apr 2001 14:57:52 +0000 |
| Subject: | Table Relationships | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-47446@lists.php.net to get a copy of this message | ||
I have two table one categories, two with relationship to table one...
Example:
Table 1
catid category
1 General Gaming News
2 Combat Flight Simulator
3 B-17 Flying Fortress
4 IL-2 Sturmovik
5 Crimson Skies
6 European Air War
Table Two
id date category desc
1 2001-04-04 14:41:33 1 Shrapnel Games....
I want to call the data from table two and if 1 matches 1 in first table it
shows "General Gaming News" instead of just 1.
understand?
please reply to email since not a list member...
David Smith
Indy Web Design
http://www.indywebdesign.com