while ($row = mysql_fetch_array($exc))

[Maarten]

while ($row = mysql_fetch_array($exc))

I've been using this for looping through SQL result from the beginning but never really gave it much thought on what it exactly does.

Now that I have to create something where I have to keep performance in mind I am wondering on what it exactly does.

1) Put the result into array $row just one time and then loop through the array

2) Put one row of the result into $row and with each loop read the fetch next row

3) something else?

[Weedpacket]

1. "mysql_fetch_array($exc)" pulls the next row from the result set $exc. If there isn't one it returns false.

2. "$row =" assigns a value to $row. It also returns the value, so "$row = whatever" has the value "whatever".

3. "while(something)" means to continue looping for as long as "something" is not false.

[Maarten]

Thx