Variable in a while($row loop
<p>Can i put a variable inside this </p>

<pre><code>while($row = mysql_fetch_array($result))
</code></pre>

<p>ie </p>

<pre><code>while($row = mysql_fetch_array($result) and color = '$color')
</code></pre>

<p>I basically am calling a query but want to report on it in sections - in this case color by color. So i'd like to loop around all my colors variables running the while loop for each one</p>
