When i try to login on my site i get the error

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /www/uuuq.com/s/o/c/soccernation/htdocs/lib/User.php on line 83

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /www/uuuq.com/s/o/c/soccernation/htdocs/lib/User.php on line 93

Warning: Cannot modify header information - headers already sent by (output started at /www/uuuq.com/s/o/c/soccernation/htdocs/lib/User.php:83) in /www/uuuq.com/s/o/c/soccernation/htdocs/public_files/login.php on line 35

i used the following
[php]$result=mysql_query($query, $GLOBALS['DB']) or die("Error: ". mysql_error(). " with query ". $query);[/php]

to output the error message and i got

Error: Table 'soccernation_d.MAC_USER' doesn't exist with query SELECT USER_ID, PASSWORD, EMAIL_ADDR, IS_ACTIVE FROM MAC_USER WHERE USERNAME = "macarius"

i would appreciate any help thanks