[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