|
|
Posted by Simon Bridgewater on 09/25/05 21:43
sorry posted at the same time..
"Simon Bridgewater" <simon@webworx.co.uk> wrote in message
news:AcCZe.3633$3q4.779@newsfe5-gui.ntli.net...
> 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]
|