MySQl Error: Help Please

[IceHSK]

I keep recieving this error..

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /*/////*/includes/sql_layer.php on line 342

Any help much appreciated..

<?php

######################################################################
# 
#
#
#
# 
#
######################################################################

if (eregi("block-Babstats_online.php",$PHP_SELF)) {
    Header("Location: index.php");
    die();
}

require_once("mainfile.php");
global $prefix, $dbi;

$time = time();
$offline = $time - 120;

$sql = sql_query("SELECT *  FROM chronos_servers WHERE last_update>$offline ORDER BY name", $dbi);
$content1 = "";
while($result = sql_fetch_array($sql, $dbi)) {
    $content1 .= "<a href=\"modules.php?name=Chronos&amp;action=servers\">$result[name]</a><br>";
}

if (!$content1) {
$content = "<br><center><i><a href='modules.php?name=Chronos&amp;action=servers'>No hosts online</a></i></center><br>";
} else {
$content = "<i>Online hosts:</i><br><br>$content1<br>";
}
?>

[IceHSK]

this is whats on line 342..

$row = mysql_fetch_array($res);

[Matt_Kindig]

The query command in mySQL is mysql_query, not sql_query. So it should be:

$sql = mysql_query("SELECT *  FROM chronos_servers WHERE last_update>$offline ORDER BY name", $dbi);

The same change goes for sql_fetch_array --> change to mysql_fetch_array.

[IceHSK]

Now getting this error.. thanks for helping

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /usr/home/****/public_html/blocks/block-Babstats_online.php on line 25

<?php

######################################################################
# 
#
#
#
# 
#
######################################################################

if (eregi("block-Babstats_online.php",$PHP_SELF)) {
    Header("Location: index.php");
    die();
}

require_once("mainfile.php");
global $prefix, $dbi;

$time = time();
$offline = $time - 120;

$sql = mysql_query("SELECT *  FROM chronos_servers WHERE last_update>$offline ORDER BY name", $dbi);
$content1 = "";
while($result = mysql_fetch_array($sql, $dbi)) {
    $content1 .= "<a href=\"modules.php?name=Chronos&amp;action=servers\">$result[name]</a><br>";
}

if (!$content1) {
$content = "<br><center><i><a href='modules.php?name=Chronos&amp;action=servers'>No hosts online</a></i></center><br>";
} else {
$content = "<i>Online hosts:</i><br><br>$content1<br>";
}
?>

[IceHSK]

Kept messin with it and finally got the right code.. thanks for trying though..