Jump to content


Photo

results page


  • Please log in to reply
No replies to this topic

#1 beav33

beav33
  • Members
  • PipPip
  • Member
  • 25 posts

Posted 27 July 2006 - 02:32 AM

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. <?php } while ($row_Recordset1 = mysql_fetch_assoc($Recordset1)); ?>

Whole code for table is <?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

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

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





0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users