[SOLVED] Getting current row number - mysql_fetch_row

[tlavelle]

This code I wrote doesn't work but illustrates what I want to do

 

 while($row = mysql_fetch_row($metric_result)) {
        echo "<tr>";
        echo "<td>".$row[0]."</td>";
        echo "<td>" . $row[1]."</td>";
        echo "<td>".$row[2]."</td>";
	echo "<td>".$myvalue[$row]."</td>";
        echo "</tr>";
    }

 

How do I generate an index for the $myvalue[] array based on the current mysql row?

[lemmin]

Is your query only returning one result? If you change this:

while($row = mysql_fetch_row($metric_result)) {

 

to:

while($row = mysql_fetch_array($metric_result)) {

 

The code that follows will work, though I'm not exactly sure it is the values you want to return.

[dbo]

Try this:

 

$len = mysql_num_rows($metric_result);
for( $i = 0; $i < $len; ++$i )
{
    $row = mysql_fetch_row($metric_result);

    echo "<tr>";
      echo "<td>" . $row[0]. "</td>";
      echo "<td>" . $row[1]. "</td>";
      echo "<td>" . $row[2]. "</td>";
      echo "<td>" . $myvalue[$i] . "</td>";
    echo "</tr>";
}

 

By using a for loop your index ($i) is your current row number. Alternatively you could just add a counter to your while loop, but I think it's pertier this way.

[tlavelle]

Thanks...the mysql_num_rows loop did it.  Now I ahve another problem : )