[thelist] MySql Select Problem

[Anthony Baratta]

At 04:20 PM 4/9/2002, Bill Bejeck wrote:

>$query="SELECT sportName,sportCaptain,captainPhone FROM sports WHERE
>venueName ='".$venueName."'";
>
>The primary key in the sports table is sportName and venueName is a foreign
>key.  My problem is this: when the results of the query are printed out I
>get the correct number of sports per venue, but the first name is repeated.
>For example, the venue DC Convention Center has Badminton,Triathlon,Swimming
>and Soccer for sports but Badminton  gets printed out 4 times.  Any ideas
>what this could be?

What happens when you drop the sportCaptain,captainPhone from the select??
---
Anthony Baratta
President
Keyboard Jockeys

"Conformity is the refuge of the unimaginative."