|
|
Posted by Sander on 09/25/05 21:30
"CyberDog" <milan-SPAM-@cdnforum.com> schreef in bericht
news:dh6o5c$q0q$1@ss405.t-com.hr...
> Hello!
>
> I have an tatable with records defined by 3 values, let's call them "id",
> "name" and "type".
>
> Now, I need to call all the records of one type, group them by the ID
> value, and put only one of the same ID in an array, how to pull this off
> without loops and easy on the load?
>
> Thank you in advance!
you need something like:
select distinct from tablename order by id;
see also: http://dev.mysql.com/doc/mysql/en/select.html
Sander Swuste
Navigation:
[Reply to this message]
|