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:[EMAIL PROTECTED]
.........................................
applying technology to transform
.........................................
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]