End of Loop?

[marcusb]

I have a php loop that is generating data from a range of queries to a remote database using a loop in this format. i am outputting the data in the format below where "java" is the field name and "132" is the result of the query.

java 132
java+unix 154
java+sybase 186
etc

i want to get the final data and insert it into mysql database after the loop is completed (so I get all the data at once and can put it into a row with the field names being java, java+unix, java+sybase, etc). I am fine with database connectivity but i can't work out how to get all the data at once...
1) is there a way to come out of the loop when it is finished and still use the outputted data?
2) should i build a php page that calls the page with the loop?
3) could i build further variables that appends each result when they come in like the code below? How can I access this when the loop completes?

$skillinput = $skillinput."'".$skills."'";
$resultinput = $resultinput."'".$resultc."'";

[steadyguy]

You could use a multidimensional array and flip through it, updating the database or building a set of UPDATE queries each time through (and then execute the set of statements all at once) ...

Is that the sort of answer you were looking for?

p.s. you could write those two lines of PHP more efficiently like this:

$skillinput .= "'$skills'";
$resultinpt .= "'$resultc'";

[marcusb]

thanks for the answer steadyguy.

i ended up going with option 2 and building a control page in php that grabs the looping page using file open and then when the loop is finished it pulls the data from the buffer and inputs it into the database.

big relief cause my application is almost finished now 😃