Question: How can I take the output of a while loop and pass it to a for loop?

I get some id from my sql db using while loop. Now, how to pass each id to select query?

For example:

```
while($row = mysql_fetch_array($sql)) {
    $y= $row['c'];
} 

```

How can I pass each $y to a select query?

Answer: 
> 
> from what I know the compiler does not optimize this kind of code
> 
> 
> 

The Hotspot JIT compiler [most definitely does](http://java.sun.com/developer/technicalArticles/Networking/HotSpot/inlining.html).

> 
> I was wondering what's the best solution?
> 
> 
> 

Stop optimizing prematurely. If you're using this code in a painting routine, I can guarantee that the actual painting will take at least a hundred times longer than calling a trivial method, even if it's not inlined.
Your solution is:
private fields,
private setters,
protected or public getters (note: protected allows access from same package as well as from subclasses)