how do i store mysql_fetch_array($query) into a variable?

[Synergic]

As part of making my code more elegant and following an mvc pattern i want to store a query result inside a variable where i can invoke it else where besides the presentation layer.

I've tried:

[code]

$result = mysql_fetch_array($quer);

while($result) {
}

ends up being an endless loop. Do i need to continue to update the variable as i scroll through the rows?

[/code]

[shocker-z]

this is what you need

[code]while ($result = mysql_fetch_array($quer)) {
//code here
}[/code]

The way you were doing it ment that while $result exists do what ever is between the brackets
The way i have shown above means that while $result can be get the next value from mysql_fetch_array($quer)

regards
Liam