use GROUP BY in your sql query. see books on SQL for details. kancha. On Fri, 19 Jan 2001 09:11:47 +0530, sarahana wrote: > 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. _______________________________________________________ Send a cool gift with your E-Card http://www.bluemountain.com/giftcenter/ -- 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]