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 . HTH. Jayme. http://www.conex.com.br/jjeffman -----Mensagem Original----- De: sarahana <[EMAIL PROTECTED]> Para: <[EMAIL PROTECTED]> Enviada em: sexta-feira, 19 de janeiro de 2001 01:41 Assunto: [PHP-DB] selecting values from column without repeating Hello, 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? thanks. -- PHP Database 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]
