Optimising php/mysql

[nic0las]

I'm trying to optimize the performance of my pages, by splitting the sql queries and the php/html output.
That is very useful in the case of a loop, like :

QUERY;
while ($tbl=RESULT) {
$VARS=$tbl["stuff"];
echo $VARS;
}

Becoming :

QUERY;
while ($tbl=RESULT) {
$i++;
$VARS=$tbl["stuff"];
$echo[$i]="$VARS";
}

$ii=count($echo);
for ($i=1; $i<=$ii; $i++){
echo "$echo[$i]";
}

This is much faster, since you just connect for a small laps of time.
But in the case of two or more while(), like this :

while(){
while(){

[nic0las]

Hmm, that's the end of the first post :

While (){
while(){
}
}

It doesn't really works, the ones that already tryied to optimize their code know what I mean...

So I'm asking : How to optimize the sql/php code, the same way I described, whitout getting blank vars and other stuffs resulting of the for() loop used to display the vars ??

Hope this is clear enough...

Thanks.