MySQL- Link resource - Error

[LiLaaron]

Hi,

I just got this error, and i have never seen it before anyone know what it is? and what i have done wrong.

my code:

global $db;



echo "<center><font color='FFFFFF' size='-1' face='Tahoma'><strong>Archive";

echo "<table border=\"0\" cellspacing=\"0\" cellpadding=\"3\" width=\"100%\"><tr><td width=\"10%\"><font color='FFFFFF' size='-2' face='Tahoma'><strong>ID</td>";

echo "<td width=\"30%\"><font color='FFFFFF' size='-2' face='Tahoma'><strong>Period</td><td width=\"20%\"><font color='FFFFFF' size='-2' face='Tahoma'><strong>Begin</td><td width=\"20%\"><font color='FFFFFF' size='-2' face='Tahoma'><strong>End</td><td width=\"20%\"><font color='FFFFFF' size='-2' face='Tahoma'><strong>Winners</td></tr>";

            //Error Pointing here (below)
$r=mysql_query("select * from sweepstakes where enable='N'", $db);
//Error Pointing here too (below)
for($i=0; $i<mysql_numrows($r); $i++) {

$f=mysql_fetch_array($r);

echo "<tr>";

echo "<td width=\"10%\"><font color='FFFFFF' size='-2' face='Tahoma'><strong>$f[id]</td>";

echo "<td width=\"30%\">";

if ($f['period']=="W") { echo "<font color='FFFFFF' size='-2' face='Tahoma'><strong>every week"; }

if ($f['period']=="M") { echo "<font color='FFFFFF' size='-2' face='Tahoma'><strong>every month"; }

if ($f['period']=="N") { echo "<font color='FFFFFF' size='-2' face='Tahoma'><strong>once"; }

echo "</td>";

echo "<td width=\"20%\"><font color='FFFFFF' size='-2' face='Tahoma'><strong>$f[date_begins]</td>";

echo "<td width=\"20%\"><font color='FFFFFF' size='-2' face='Tahoma'><strong>$f[date_ends]</td>";

echo "<td width=\"20%\"><a href=\"sweepstakes.php?action=2&id=$f[id]\"><font color='FFFFFF' size='-2' face='Tahoma'><strong>click here</a></td>";



echo "</td></tr>";

}



echo "</table>";

echo "</center>";

Thanks
Aaron

[laserlight]

1. Check the database server connection.
2. Check that a database has been selected.
3. Check that the SQL statement is correct.

Oh, and use mysql_num_rows(). mysql_numrows() has been deprecated.