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 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]