mysql_query not static?

[deep]

I was making a class that will handle my db connections and i noticed that

$r = mysql_fetch_array(mysql_query($sql));

and

$q = mysql_query($sql);
$r = mysql_fetch_array($q);

do not give the same result... if you put example One in a while() loop it will keep on going for ever..

Normaly I would think that in this case creating a $q variable only makes the code more readble but im guessing mysql_query() is not static so it will start over every time the fetch_array is called... ?

[jonno946]

if you put the first one in a loop you would just be running another query on every iteration and will probably grind your web server to a hault.

like you said, creating a variable containing the mysql result resource, and looping through that would be the most appropriate method.