i had my site running great on another server. i just moved the site to a new server (different host) and now im getting this error:
Warning: mysql_fetch_object(): The result type should be either MYSQL_NUM, MYSQL_ASSOC or MYSQL_BOTH. in /public_html/i.tab.php on line 259
its got more of those, on different lines.. each of the lines point to this..
<?
////////////////database queries start/////////////
$query = mysql_query("SELECT member_name FROM member WHERE member_status = 'A'");
$rows1 = mysql_num_rows($query);
$query = mysql_query("SELECT member_name FROM member WHERE member_status = 'I'");
$rows2 = mysql_num_rows($query);
$query = mysql_query("SELECT member_name FROM member WHERE member_status = 'D'");
$rows3 = mysql_num_rows($query);
$query = mysql_query("SELECT image_id, image_size FROM image WHERE image_status = 'A'");
while($data4 = mysql_fetch_object($query, $db)) {
$size4 = $size4 + $data4->image_size;
}
$rows4 = mysql_num_rows($query);
$query = mysql_query("SELECT image_id, image_size FROM image WHERE image_status = 'D'");
while($data5 = mysql_fetch_object($query, $db)) {
$size5 = $size5 + $data5->image_size;
}
$rows5 = mysql_num_rows($query);
/////////////////queries end///////
?>
<td><font size=2> Active Members: <?php print($rows1); ?>
</td>
</tr>
<tr>
<td><font size=2> Hosted Images: <?php print($rows4); ?>
(etc.. through the different rows)
is it something that my new server isnt configured for? i never got this error before on my other site.. and the only difference that i know of, is the database name was changed (but reflected upon that change) other than that.. i dont know.. i need help!!
