> Is it possible to exclude identical value's using a mysql query statment? > > E.g. I've got 2 colums named BlaID and BlaInfo. > BlaID may contain 20 times the value 75 and 10 times the value 54. > What I want to do is being able to retrieve the value 75 and 54 only > once (with the vlue of BlaInfo). > > Is this possible to do with one statement?
I'm not sure what you're asking for. Are you saying if you had a table like BlaID BlaInfo 75 100 54 125 75 90 54 110 You'd want a result like ------------------------------------ | BlaInfo | BlaID | ------------------------------------- | | 75 | | | 54 | | 100 | | | 125 | | | 90 | | | 110 | | ------------------------------------- ? Perhaps an example would clear things up of what you would like =) Sincerely, Craig Vincent -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php