PHP Code:
$result = mysql_query("SELECT * FROM hockeystats_teams ORDER BY dates DESC");
$count=0;
if(mysql_num_rows($result))
{
echo "<font face=Arial size=+1>Online Applications List</font><p>";
echo "<font face='Arial' size=2>Here is the complete list of applications currently stored in the database. To view the application just click on the persons name.</font>";
echo "<table cellspacing=5 cellpadding=5 border=0 width='100%'>";
echo "<tr><td><font face='Arial' size=2><b>Applicants Name</b></font></a></td><td><font face='Arial' size=2><b>Date Applied</b></font></td><td><font face='Arial' size=2><b>Application Status</b></font></td><td><font face='Arial' size=2><b>Applicants Phone</b></font></td><td><font face='Arial' size=2><b>Applicants E-mail</b></font></td></tr>";
while($row=mysql_fetch_array($result))
{
$count=$count+1;
$team=$row["team"];
$gp=$row["gp"];
$wins=$row["wins"];
$losses=$row["losses"];
$ties=$row["ties"];
$goalsagainst=$row["goalsagainst"];
$goalsfor=$row["goalsfor"];
$points=$row["points"];
Here's the error:
----------------------
Warning: mysql_num_rows(): supplied argument is not a valid
MySQL result resource in
----------------------
(without the lines), what is wrong, I looked over it and it isn't much different to my other scripts except looking for a different table.... hoping someone would notice it as I've been staring at this thing too long... thanks.
I also searched the forum and the fixes that were proposed don't apply as I don't have the thing "$connection" that most people have.
Comment