[thelist] MySql Select Problem
Martin Kuplens-Ewart
martin at takingitglobal.org
Tue Apr 9 20:22:00 CDT 2002
Try
$query = "SELECT DISTINCT sportNAME FROM sports WHERE venueName =
'".$venueName."'";
[I'm not sure if you can add more comma-seperated field names after the
DISTINCT sportName clause]
-m
> 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?
It could always be an issue with your loop... More code to look at would
help.
-martin
More information about the thelist
mailing list