Re: New Houses Mod [Mccodes V2]
<th width="25%">House name</th>
<th width="25%">Owner</th>
<th width="25%">Mood value</th>
<th width="25%">Manage</th>
</tr>';
if(!mysql_num_rows($houses))
{
echo '<tr>
<td colspan="5">You have no houses at this time, purchase one at the estate agent\'s.</td>
</tr>';
}
while($r = mysql_fetch_assoc($houses))
{
echo '<tr>
<td>'.stripslashes($r['hNAME']).'</td>
<td>.'"]'.stripslashes($r['username']).'</td>
<td>'.number_format($r['uhouseMood']).' mood bar</td>
these are the errors that go with it
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/benan/public_html/houses.php on line 49
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/benan/public_html/houses.php on line 55
this is line 44 to 60 shows that thier is an error on line 49 and 55, yet i had it working fine yesterday and it looks as if i may have everything in the right spot, any help would be appreciated :)
