[RESOLVED] mysql_fetch_row problem

NoBullMan

Hi,
I have a problem and don't know how to resolve it. I connect to database and run a query. When I try to do a mysql_fetch_rows, it doesn't work. If I just get the number of rows returned and go through them it works fine.

$sql="Select * from tbProducts";
$result = mysql_query($sql) or die("Invalid query: " . mysql_error());
$n = mysql_num_rows($result);

for ($i = 0; $i < $n; $i++) {   // this works
    printf("Name: %s<br>\n", mysql_result($result,$i,"ProdName"));
    printf("Price: %s<br>\n", mysql_result($result,$i,"ProdPrice"));
}

while ($row = mysql_fetch_row($result) {  // this doesn't work!
    printf("Name: %s<br>\t", $row["ProdName"]);
    printf("Price: %s<br>\n", $row["ProdPrice"]);
}

Thanks,

laserlight

You are looking to use mysql_fetch_assoc() instead. mysql_fetch_row() returns an array with numeric indices. If the code snippet is directly from your test code, then I must warn that you are missing a mysql_data_seek() to reset the row pointer.

NoBullMan

Thanks for the reply. I tried that and still didn't work. I tried mysql_fetch_array($result, MYSQL_BOTH) as well, but no luck.

The sample code I included is from my code but I comment out one and use the other to test.

NoBullMan

What is interesting is that when I use the mysql_fetch_array or mysql_fetch_row, it seems nothing in the page gets executed. I have a bunch of echo statements that should display regardless but nothing on the page gets echo'ed!

laserlight

hmm... but it works for mysql_result()?

Try this:

$sql = "Select ProdName, ProdPrice from tbProducts";
$result = mysql_query($sql) or die("Invalid query: " . mysql_error());

while ($row = mysql_fetch_assoc($result)) {
    printf("Name: %s<br>\t", $row["ProdName"]);
    printf("Price: %s<br>\n", $row["ProdPrice"]);
}

I hope that you have error_reporting set to E_ALL, because your original code had a typo error (missing closing parenthesis).

NoBullMan

Her is the code, can you see if it works on your side?
Could this be an hosting issue (I have external hosting)?

  

$hostname = "myhostid";
$database = "mydb";
$username = "myid";
$password = "mypwd";
$conn = mysql_pconnect($hostname, $username, $password);
echo "hostname: $hostname, database: $database, username: $username, password: $password <br />";
  if (!$conn)
    echo 'failed in mysql_pconnect<br />';
  else
  {
  	echo "connected to host $hostname<br />";

if (!mysql_select_db($database))
  echo 'failed in mysql_select_db<br />';
else{
	echo "selected database $database<br />";

  	$sql="Select * from tbProducts";
  	$result = mysql_query($sql) or die("Invalid query: " . mysql_error());
  	echo "result: $result<br />";
	$n = mysql_num_rows($result);
	echo "number of rows returned: $n<br />";
/*		for ($i = 0; $i < $n; $i++)
		{
		  printf("Name: %s<br>\n", mysql_result($result,$i,"ProdName"));
	  		printf("Price: %s<br>\n", mysql_result($result,$i,"ProdPrice"));
		}*/
		while ($row = mysql_fetch_row($result)
		{
			printf("Name: %s<br>\t", $row["ProdName"]);
			printf("Price: %s<br>\n", $row["ProdPrice"]);
		}
		mysql_free_result($result);
	  	mysql_close($db);
    }
  }

Thanks.

NoBullMan

Darn it! That was the problem (missing ')' ). My code is hosted through a hosting company and probably they don't have the error reporting set to E_ALL.

Thanks for your help.

laserlight

You're welcome 🙂
Remember to mark this thread resolved (if it is).

You might also considering installing a web server, MySQL and PHP on your computer for local testing. It certainly would save your bandwidth, and can be faster too.