Question
mysql_fetch_assoc()
I created a db and added content to it. Now I want to get it
out. I created a recordset for a simple search for houses buy
state.
It works fine in the test, but when I add the dynamic table I get this on the page
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in C:\wamp\www\offers4house\results.php on line 12
I have followed every help page and still cant figure it out. Line 12 is the next to last line of this code for the dynamic table
<table border="1" cellpadding="1" cellspacing="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>
I can include the rest of the dreamweaver php for the recordset and query if needed.
Please Please Please! Help
Michael
It works fine in the test, but when I add the dynamic table I get this on the page
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in C:\wamp\www\offers4house\results.php on line 12
I have followed every help page and still cant figure it out. Line 12 is the next to last line of this code for the dynamic table
<table border="1" cellpadding="1" cellspacing="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>
I can include the rest of the dreamweaver php for the recordset and query if needed.
Please Please Please! Help
Michael
AdChoices