I have a database in ultradev that contains a column for bus routes. Each ID may contain several routes. I want to select distinct route numbers from this column. It's working, sort of. For example, when I enter route 22, I get route 22, but I also get route 122.

Please help. I'm almost there.

Thanks

select distinct(route_id) from <i>table</i>

this will show you all the records without repetition. although i don't think this is what you wanted. can you elaborate more on the question?

www.mysql.com/doc/en/SELECT.html

------------------------
Julio Mellado

PHP | MySQL | UD4

ICQ: 19735247
MSN: