You can avoid record repetition using the "distinct" keyword in the "select"
command :
"select distinct * from table where <condition>"
Remember that all the table fields you put in the select query will be
present in all fetched records. If you do not want to show some field in
every line you must build a page taking care of this matter in the php
script .



-----Mensagem Original-----
De: sarahana <[EMAIL PROTECTED]>
Enviada em: sexta-feira, 19 de janeiro de 2001 01:41
Assunto: [PHP-DB] selecting values from column without repeating

I was wondering if it would be possible to select values from a column (lets
say the column "year") so that each value gets retrieved only once... for
example, there are multiple rows in a table - some with '2001' as the value
for the year column, and some with '2000'. Now, what I wanted to do is list
the values of the year so that 2001 shows up only once, and 2000 shows up
only once without repeating... is this possible?


PHP Database Mailing List (
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to