Having problems with my download script

[starfi3ld]

I got a few errors with this script

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/starfi3ld/domains/starfi3ld.com/public_html/newreleases.php on line 15

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/starfi3ld/domains/starfi3ld.com/public_html/newreleases.php on line 70

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/starfi3ld/domains/starfi3ld.com/public_html/newreleases.php on line 73

<?php
 
include("header.php");
 
define('IN_PHPBB', true);
$phpbb_root_path = 'Forum/';
include($phpbb_root_path . 'extension.inc');
include($phpbb_root_path . 'common.'.$phpEx);
$userdata = session_pagestart($user_ip, PAGE_INDEX);
init_userprefs($userdata);
 
if ($userdata['session_user_id'] != "") {
    $qry = "select access_level from list_users where user_id=".$userdata['session_user_id'];
    $result = mysql_query($qry,$dbi);
    if (mysql_num_rows($result) > 0) {
        list($acclvl) = mysql_fetch_row($result);
        $path = "/donators";
    } else {
        $acclvl = "1";
        $path = "/users";
    }
} else {
    $acclvl = "1";
    $path = "/users";
}
 
if ($_GET['mode'] == "list") {
    $qry = "select distinct date(file_date) from list_anime where access_level<=$acclvl order by file_date desc";
    $result = mysql_query($qry,$dbi);
    $numrows = mysql_num_rows($result);
    echo "<table width=\"100%\" border=\"0\" cellspacing=\"0\" cellpadding=\"1\">\n"
        ."<tr><td></td></tr>\n";
    for ($i=0;$i<$numrows;$i++) {
        list($lstdate) = mysql_fetch_row($result);
        $lstdatecust = dateconvert($lstdate);
        echo "<tr><td nowrap>"
            ."<strong>:&middot;</strong>&nbsp;<a href=\"newreleases.php?mode=date&amp;datepick=".substr($lstdate,0,12)."\">".substr($lstdatecust,0,12)."</a>"
            ."</td></tr>\n";
    }
    echo "</table>\n";
} elseif ($_GET['mode'] == "date") {
    $datepick = $_GET['datepick'];
    $qry = "select id,file_name,server,location from list_anime where access_level<=$acclvl and file_date like '$datepick%' order by file_name asc";
    $result = mysql_query($qry,$dbi);
    $numrows = mysql_num_rows($result);
    $datepick = dateconvert($datepick);
    if ($numrows != 0) {
        echo "<table width=\"100%\" border=\"0\" cellspacing=\"0\" cellpadding=\"1\">\n"
            ."<tr><td style=\"border-bottom-style:inset; border-bottom-width:thin; border-top-color:#FFFFFF\">".substr($datepick,0,12)."</td></tr>\n"
            ."<tr><td></td></tr>\n";
        for ($i=0;$i<$numrows;$i++) {
            list($id,$file,$svr,$loc) = mysql_fetch_row($result);
            if (eregi("backup",$loc)) {
                $mdir = "anime2";
            } else {
                $mdir = "anime";
            }
            $lnk = base64_encode($file."|".$loc."|".$mdir);
            echo "<tr><td nowrap>"
                ."<strong>:&middot;</strong>&nbsp;<a href=\"".$svr.$path."/getfile.php?fileid=$id&amp;lnk=$lnk\">$file</a>"
                ."</td></tr>\n";
        }
        echo "</table>\n";
    }
    echo "<br><br>\n<div align=\"right\"><a href=\"newreleases.php?mode=list\">Archives</a></div>\n";
} else {
    //list file based on latest entry date
    $qry = "select file_date from list_anime where access_level<=$acclvl order by file_date desc";
    $result = mysql_query($qry,$dbi);
[/b]    list($latestdt) = mysql_fetch_row($result);
    $qry = "select id,file_name,server,location from list_anime where access_level<=$acclvl and file_date like '".substr($latestdt,0,10)."%' order by file_name asc";
    $result = mysql_query($qry,$dbi);
    [b]$numrows = mysql_num_rows($result);
    $latestdt = dateconvert($latestdt);
    if ($numrows != 0) {
        echo "<table width=\"100%\" border=\"0\" cellspacing=\"0\" cellpadding=\"1\">\n"
            ."<tr><td style=\"border-bottom-style:inset; border-bottom-width:thin; border-top-color:#FFFFFF\">Last update: $latestdt</td></tr>\n"
            ."<tr><td></td></tr>\n";
        for ($i=0;$i<$numrows;$i++) {
            list($id,$file,$svr,$loc) = mysql_fetch_row($result);
            if (eregi("backup",$loc)) {
                $mdir = "anime2";
            } else {
                $mdir = "anime";
            }
            $lnk = base64_encode($file."|".$loc."|".$mdir);
            echo "<tr><td nowrap>"
                ."<strong>:&middot;</strong>&nbsp;<a href=\"".$svr.$path."/getfile.php?fileid=$id&amp;lnk=$lnk\">$file</a>"
                ."</td></tr>\n";
        }
        echo "</table>\n";
    }
    echo "<br><br>\n<div align=\"right\"><a href=\"newreleases.php?mode=list\">Archives</a></div>\n";
}
 
include("footer.php");
 
?>

Can anyone help me with this? This is a new releases script connected to my downloads database... It is supposed to show the latest file entries and keep an archive of it... I'm not sure what i did wrong.... i'm using
Mysql Server version: 4.1.21-standard
and also Direct admin as my server CP

[starfi3ld]

erm adding to that, The scripts used to work until i transferred the site unto another server... So I'm quite confused now..

Line 15 is in bold

If you cant find line 70 and 73, search for
list($latestdt) = mysql_fetch_row($result); - Line 70

$numrows = mysql_num_rows($result); - Line 73

[Motoma]

You never called mysql_connect() to establish your database connection.