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]

Reply via email to