I am stuck and don't known while the "temp"-variable in the rs2 while loop only returns the first temp entry (temp I a global variable)
rs= db.SQLSelect("SELECT * FROM `schedule` WHERE `FromDT` < "+seconds.ToText+"")
rs2= db.SQLSelect("SELECT * FROM `campaign`")
If rs <> Nil then //return 2 entries
While Not rs.EOF
msgbox temp //showing first entry and after rs.movenext showing second entry, which is right...
While Not rs2.EOF
msgbox temp. ///always showing only first entry, if rs2 has e.g. 5 entries, it must be showing 5 times the temp variable from the first rs temp and 5 times the second rs temp, or am I wrong?
any help, please?