[RESOLVED] num_rows echos only one digit

eVrn

What would cause my readout to print only the first digit in a two digit result?

$result = mysql_query("SHOW tables", $db);

echo "<BR><BR><B>Current Tables:</B><BR>";
while($row = mysql_fetch_row($result)){
	$rowA[0] = str_replace ("_", " ", $row[0] );
	$query2 = "SELECT COUNT(*) FROM $row[0]";
	$result2 = mysql_query($query2);
	$count = mysql_result($result2,0,0);
	echo $rowA[0]. " has <SPAN STYLE='color:red;'>" .$count[0]. "</SPAN> records.<BR>";
}

But if I count the rows without a variable for the table name, it works fine.

$result2 = mysql_query("SELECT * FROM table1", $link);
$num_rows = mysql_num_rows($result2);

Not sure what is causing this. Also not sure where to search for answers.

bradgrafelman

Try doing a SELECT COUNT(*) statement in an interface w/ MySQL (CLI, phpMyAdmin, etc.). You'll find that it actually returns the number of rows selected in a row as other normal SELECT queries would.

eVrn

If I understand your response correctly, I am doing the wrong thing here? So what SHOULD I do to get the results I need?

bradgrafelman

If you do a COUNT(*) query, you want to retrieve the resulting data just like you would with any other SELECT statement.

In this case, you could just use [man]mysql_result/man.

NogDog

Short answer: Change $count[0] to just $count in your output statement.

Long answer: I think the problem is that in your output statement you refer to $count[0], but you are assigning the value to scalar variable $count. Therefore, since it is not an array, it is being treated as a string, so $count[0] is referring to the first character of the string $count.

eVrn

That did the trick NogDog. I think I get it. Had I used $count[1] it would have returned the SECOND digit, rather than the first, right? Looks like mistake was thinking the count had to also be an array.

Thanks so much for the help.

bradgrafelman

eVrn wrote:
Had I used $count[1] it would have returned the SECOND digit, rather than the first, right? Looks like mistake was thinking the count had to also be an array.

Exactly right on both counts.