January 21st, 2004, 09:33 AM
|
|
Contributing User
|
|
Join Date: Jan 2004
Location: essex UK
Posts: 184
Time spent in forums: 1 Day 4 h 2 m 39 sec
Reputation Power: 5
|
|
|
tables one to many only getting one to one
SQL Version 3.23
2 tables members and games
query:
PHP Code:
$sql = "INSERT INTO wintera SELECT
games.membershipSeq,members.sortFlag,members.membershipID,
members.firstName,members.lastName,members.handicapStart,
games.gameSeq,games.gameDate,games.gameQuarter,games.gameMonth,
games.numberStrokes,games.handiCap,games.gameScore,games.lateScore,
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 09:35 AM.
|
Dev Shed Forums Sponsor:
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
