PHP & MSSQL - SQL Loop within another SQL loop?
Posted on 2011-02-28
I'm trying to run a sql query (as a loop) within another sql loop thats already running, unfortunately, im not getting any results from the inner query - a basic example of what im trying to do is:
while($query1 = mysql_fetch_array($querycode1))
while($query2 = mysql_fetch_array($querycode2))
In that example it doesnt sound logical having a loop within a loop, but the second query uses variables from the first to make it work if that makes sense.
Does anyone know where im going wrong - is it possible to do what im trying to do?!