I'm attempting to do a select via PHP where I want to get a list of unique
records for example if my table is as follows
+-------------+----------+
| bluefish    |  blah    |
+-------------+----------+
| bluefish    |  blah    |
+-------------+----------+
| redfish     |  blah    |
+-------------+----------+
| greenfish   |  blah    |
+-------------+----------+
| redfish     |  blah    |
+-------------+----------+

I want it to return only "bluefish,redfish,greenfish" when I make a query on
the first field.  Does anyone know how this is possible?

Matt "TrollBoy" Wiseman
Webmaster: Shoggoth.net
Site Designer: phpslash.org
The oldest and strongest emotion of mankind is fear,
and the oldest and strongest kind of fear is fear of the unknown.
-H.P. Lovecraft
---------------------------------------------------------
Please do not resell my e-mail address
to anyone or send me unsolicited e-mail
---------------------------------------------------------



---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Reply via email to