SELECT BlaID, MAX(BlaInfo) AS Info
FROM mytable GROUP BY BlaId
"Prodoc" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> ok, sorry about that :-)
>
> Table:
> BlaID
> BlaInfo
> 20
> 4
> 17
> 8
> 20
> 9
> 15
> 81
> 20
> 12
> 20 23
> 17
> 0
>
> Result:
> BlaID
> BlaInfo
> 15
> 81
> 17 0
> 20
> 9
>
> I don't realy care about the value's I get in BlaInfo as long as I get
> one of those value's...
> I asume this is a very simple instruction but I just started using
> php+mysql so I don't know the propper words I could use to do a search :-)
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
