|
|
Posted by Simon Bridgewater on 09/25/05 21:42
if you only want an array with the id
then
SELECT distinct(id) FROM the_table where type='whatever';
"CyberDog" <milan-SPAM-@cdnforum.com> wrote in message
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!
Navigation:
[Reply to this message]
|