Jump to content


Photo

Mysql/Php returning from two tables


  • Please log in to reply
1 reply to this topic

#1 esiason14

esiason14
  • Members
  • PipPipPip
  • Advanced Member
  • 58 posts

Posted 05 March 2006 - 06:31 PM

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 stats

I'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]

#2 fenway

fenway
  • Staff Alumni
  • MySQL Si-Fu / PHP Resident Alien
  • 16,199 posts
  • LocationToronto, ON

Posted 06 March 2006 - 11:04 AM

Post the offending query that are resulting in the unexpected output.
Seriously... if people don't start reading this before posting, I'm going to consider not answering at all.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users