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] Quote 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. Quote 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
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.