esiason14 Posted March 5, 2006 Share Posted March 5, 2006 I have two tables that I want to pull from:players (has players_id, position_id, First name, last name, mlbteam)playerstats (has a list of all stats....stat_id, player_id, year, ab, hits, hr, rbi....etc)Hitters (Catchers, second base, thirdbse, firstbase, ss, of) and Pitchers (Starting and Relief) all have different statsI've got the "Leaders Page" done, but I'm trying to build individual player pages where each players stats will show by year. For some reason, all of the stats on these pages are showing as 0...[a href=\"http://www.fantasybaseballresearch.com/baseball/2bleaders.php\" target=\"_blank\"]Here's the leaders page:[/a][a href=\"http://www.fantasybaseballresearch.com/baseball/players.php?player_id=404\" target=\"_blank\"]Hers a player page[/a] Link to comment https://forums.phpfreaks.com/topic/4155-mysqlphp-returning-from-two-tables/ Share on other sites More sharing options...
fenway Posted March 6, 2006 Share Posted March 6, 2006 Post the offending query that are resulting in the unexpected output. Link to comment https://forums.phpfreaks.com/topic/4155-mysqlphp-returning-from-two-tables/#findComment-14593 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.