January 21st, 2004, 10:33 AM
Join Date: Jan 2004
Location: essex UK
Time spent in forums: 1 Day 5 h 27 m 2 sec
Reputation Power: 10
tables one to many only getting one to one
SQL Version 3.23
2 tables members and games
$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";
3rd table wintera created as a temporary.
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.
I love perl
Last edited by byte me : January 21st, 2004 at 10:35 AM.