[Resolved] can't read rows

seriv

I got this script to display a table with the values from my mysql database, but I get this error, Warning: mysql_numrows(): supplied argument is not a valid MySQL result resource in /home/seriv/public_html/mem/testdatabase.php3 on line 39
here is the script:
<html>
<head><title>Inventory</title>

<?
//include stylesheet for formatting
include("databasestyle.php3");
?>

</head>
<body>

<?
// script to display who has which computers

// connection information
$hostName = "***********";
$userName = "****";
$password = "*****************";
$dbName = "**********";

// make connection to database
mysql_connect($hostName, $userName, $password) or die("Unable to connect to host $hostName");

mysql_select_db($dbName) or die("Unable to select database $dbName");

// Select the fields from the appropriate tables

$query =
"SELECT members.database_ID, members.username,
members.handle, members.rank, members.date_joined, members.departments,
members.email, members.pfile, members.ip, members.IM
FROM members
ORDER BY members.database_ID, members.username,
members.handle, members.rank, members.pfile";

$result = mysql_query($query);

// Determine the number of records returned
$number = mysql_numrows($result);

// Print the relevant information

print "<h2>There are $number records in the inventory:</h2>
<table cellpadding=5>
<tr bgcolor=black>
<td>database ID#</td>
<td>Handle</td>
<td>Username</td>
<td>Rank level</td>
<td>Date member joined</td>
<td>Departments</td>
<td>e-mail</td>
<td>pfile</td>
<td>IP</td>
<td>IM</td></tr>";
for($i=0; $i<$number; $i++) {
$database_ID = mysql_result($result, $i, "database_ID");
$username = mysql_result($result, $i, "username");
$handle = mysql_result($result,$i,"handle");
$rank = mysql_result($result,$i,"rank");
$date_joined = mysql_result($result,$i,"date_joined");
$departments = mysql_result($result,$i,"departments");
$email = mysql_result($result,$i,"email");
$pfile = mysql_result($result,$i,"pfile");
$ip = mysql_result($result,$i,"ip");
$IM = mysql_result($result,$i,"IM");
/ print even-numbered rows with a grey background,
odd-numbered with a white background /
if ($i%2 == 0) {
print "<tr bgcolor=lightgrey>";
} else {
print "<tr>";
}
print "<td>$database_ID</td>
<td>$username</td>
<td>$handle</td>
<td>$rank</td>
<td>$date_joined</td>
<td>$departments</td>
<td>$email</td>
<td>$pfile</td>
<td>$ip</td>
<td>$im</td></tr>";
}
print "</table>";

// Close the database connection
mysql_close();
?>

</body>
</html>

stolzyboy

that's because this

$number = mysql_numrows($result);

should be this

$number = mysql_num_rows($result); //notice extra underscore

seriv

I still get the same error.
-thanx
-Seriv😕

stolzyboy

change this

$result = mysql_query($query);

to this

$result = mysql_query($query) or die(mysql_error());

and let us know what error that gives you

seriv

Thanks for your help, was just a typo in my table name, sorry for wasting time.
-Seriv