Help performing simple query - PHPBuilder Forums

Help performing simple query

Anon

Hi,

I am getting a 0 is not a mysql index error in this code:

<body>
<?php $db = mysql_connect("localhost", "username", "password");
mysql_select_db("min_add.txt",$db);
$sql_query = "SELECT * FROM Minerals";
$eresult = mysql_query($sql_query,$db);
while($row = mysql_fetch_array($eresult)) {
echo $row[Mineral_Name];
echo $row[Formula];
}
?>
</body>

The error occurs at this line:
while($row = mysql_fetch_array($eresult)) {

Any suggestions?

Anon

First, insert some if{} statements to check if your initial connection to the DB works at all.
Then insert some if{} to check if your query was executed.
Then check if there are any results in $eresults.

Tip: print the mysql errors (read the PHP manual)

Anon

Hi,

Try adding some code like this:

<body>
<?php $db = mysql_connect("localhost", "username", "password") or die("connect error: " . mysql_error());
mysql_select_db("min_add.txt",$db) or die("select_db error: " . mysql_error());
$sql_query = "SELECT * FROM Minerals" ;
$eresult = mysql_query($sql_query,$db) or die("query error: " . mysql_query());
while($row = mysql_fetch_array($eresult)) {
echo $row[Mineral_Name];
echo $row[Formula];
}
?>
</body>

cheers,

roel