Error: 0 is not a result index

Hi,

I am doing a simple query on a mysql database called min_add.txt with the following code:

I want to display all results from the minerals table. I keep on getting this error:

Warning: 0 is not a MySQL result index on line 7

The culprit is this line
while($row = mysql_fetch_array($eresult))
but I can't find anything wrong. Any suggestions?

Looks like your query did not return any results from the database.

Try printing a mysql_num_rows($eresult);
before your while loop.
That prints the number of results in your query.

Hi,

I get the same error when I try to print the number of results.

look at the lines:

$sql_query = mysql_query("SELECT * FROM Minerals",$db);
$eresult = mysql_query($sql_query);

this reduces to:

$eresult=mysql_query(mysql_query("SELECT * FROM Minerals",$db));

which won't work 🙁
if you still want to build the query seperately (which can be handy), do

$sql_query = "SELECT * FROM Minerals";
$eresult = mysql_query($sql_query,$db);

--
rad