January 21st, 2004, 09:33 AM
tables one to many only getting one to one
SQL Version 3.23
2 tables members and games
3rd table wintera created as a temporary.
$sql = "INSERT INTO wintera SELECT
games.whenUpdated FROM games,members
WHERE games.membershipSeq=members.membershipSeq AND
games.gameQuarter ='$myquarter' AND
games.disqualifiedGame='$dis'AND members.sortFlag ='$sortTest'ASC";
This only loads results 1 member 1 game
I need to load 1 member 12 games
I am new to MySQL so all help appreciated.
Last edited by byte me; January 21st, 2004 at 09:35 AM.
I love perl
January 21st, 2004, 04:18 PM
[consults crystal ball to see the data values in your tables...]
aha! it's your gafloozle column, it's got bad data in it!
okay, seriously, your join condition is probably wrong
at least, that's what i'm guessing, going strictly by intuition based on the column names you've used