asterisk users - Sep 2009 - Query result is array of elements, how to iterate over it ??

Hey list,

suppose I have several dates in a database-table, where these dates are
marked as 'set' or 'not set'.

If I do something like :
SELECT ID FROM my_table WHERE client=clientID AND set=yes

and this query results in several rows and thus several ID's like "2 5
7
11 13 14 17"...

How can I iterate over these values ??

Something like :

for each item in ARRAY {
SELECT asterisk_syntax FROM other_table WHERE dateID=$item
}

This query would result in something like *|*|7|may.

How to iterate over an array of results ???

Jonas.
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
http://lists.digium.com/pipermail/asterisk-users/attachments/20090909/23ff5dd1/attachment.htm