results page

[beav33]

[b]In my site I set up a search page to probe the db. In dreamweaver I used a recordset, then to display the info, I used a dynamic table. Every test works fine but when uploaded the results page shows an error coming I think from the dynamic table code from this. [/b] <?php } while ($row_Recordset1 = mysql_fetch_assoc($Recordset1)); ?>

[b]Whole code for table is [/b] <?php
mysql_free_results($Recordset1);
?>
<table border="1" cellpadding="1">
<tr>
<td>state</td>
</tr>

<?php do { ?>
<tr>
<td><?php echo $row_Recordset1['state']; ?> </td>
</tr>
<?php } while ($row_Recordset1 = mysql_fetch_assoc($Recordset1)); ?>
</table

[b]ERROR on page[/b]
Warning: mysql_fetch_assoc(): is not a valid MySQL result resource in C:\wamp\www\offers\results.php on line 68

[b]Has anyone had this problem, or knows what this function is or why I am getting it.
Any help Please
Thank you
beav33[/b]