<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 TRANSITIONAL//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; CHARSET=UTF-8">
<META NAME="GENERATOR" CONTENT="GtkHTML/3.24.5">
</HEAD>
<BODY>
Hey list,<BR>
<BR>
suppose I have several dates in a database-table, where these dates are marked as 'set' or 'not set'.<BR>
<BR>
If I do something like :<BR>
SELECT ID FROM my_table WHERE client=clientID AND set=yes<BR>
<BR>
and this query results in several rows and thus several ID's like "2 5 7 11 13 14 17"...<BR>
<BR>
How can I iterate over these values ??<BR>
<BR>
Something like :<BR>
<BR>
for each item in ARRAY {<BR>
SELECT asterisk_syntax FROM other_table WHERE dateID=$item<BR>
}<BR>
<BR>
This query would result in something like *|*|7|may.<BR>
<BR>
How to iterate over an array of results ???<BR>
<BR>
Jonas.
</BODY>
</HTML>