Hi,

I have DW8, mysql, php4.2.3(clients). I am creating an insert record form with a dynamic menu in it. I am using a recordset, rs tests fine. but my list only shows first record. I echoed my row count, 23 there. Not sure why. PLEASE HELP on day 2 of trying

<pre id=code><font face=courier size=2 id=code>&lt;tr valign="baseline"&gt;
&lt;td nowrap align="right"&gt;Color:&lt;/td&gt;
&lt;td&gt;&lt;select name="Color"&gt;
&lt;?php
do {
?&gt;&lt;option value="&lt;?php echo $row_rsColorCat['colorName']?&gt;"&gt;&lt;?php echo $row_rsColorCat['colorName']?&gt;&lt;/option&gt;
&lt;?php
} while ($row_rsColorCat = mysql_fetch_assoc($rsColorCat));
$rows = mysql_num_rows($rsColorCat);
if($rows &gt; 0) {
mysql_data_seek($rsColorCat, 0);
$row_rsColorCat = mysql_fetch_assoc($rsColorCat);
}
?&gt;
&lt;/select&gt;
&lt;/td&gt; </font id=code></pre id=code>