[Resolved] newbie moment, problem with mysql_numrows

[eternalprophet]

Hrm, I don't know why I am getting this error message:

Warning: mysql_numrows(): supplied argument is not a valid MySQL result resource in /home/REMOVED/public_html/gardening/display.php on line 15

Here is that portion of the code:

mysql_connect(localhost,$username,$password);
@mysql_select_db($db) or die( "Unable to select database");
$query='SELECT * FROM ffxigtmain';
$result=mysql_query($query);

$num=mysql_numrows($result);

echo "<b><center>Database Output</center></b><br><br>";

I have tried using single and double quotes around the $query value. Does anyone have a clue what I broke? 🙂

[tomhath]

Put localhost in quotes, get rid of the @ in front of the mysql_select_db, and check the error message after each mysql_* function call.

Try it this way, obviously the mysql_query failed for some reason:

mysql_connect('localhost',$username,$password) or die( mysql_error());
mysql_select_db($db) or die( mysql_error());
$query='SELECT * FROM ffxigtmain';
$result=mysql_query($query) or die( mysql_error());

$num=mysql_numrows($result);

echo "<b><center>Database Output</center></b><br><br>";

[eternalprophet]

was selecting ffxigtmain isntead of ffxigtMain. Stupid case sensitivity.

Thanks for the help

[PHPMagician]

You could also do this query:

SELECT count(*) FROM database

And it return the number of fields.