Re: MySql Help

At 12:31 PM -0600 9/11/01, Jared Mashburn wrote:

I am tring to run a query On the First Column and place the data into an array. The problem that I am running into Is that there are doubles, triples, and sometimes more of the same name in that column. Each name represents something differnet in the "Second" and "Third" and when I run a simple query (select "first" from "table") I get (expectedly) all of the names in the Column "doubles" and all. My question is , is there a way to select from a database and only select one of each name from the column?

SELECT DISTINCT field1 FROM table1 ORDER BY field1 Alnisa -- ......................................... Alnisa Allgood Executive Director Nonprofit Tech (ph) 415.337.7412 (fx) 415.337.7927 (url) http://www.nonprofit-techworld.org (url) http://www.nonprofit-tech.org (url) http://www.tech-library.org ......................................... Nonprofit Tech E-Update mailto:nonprofit-tech-subscribe@egroups.com ......................................... applying technology to transform .........................................