Counting / showing mysql Rows

[coolcat]

by using either

mysql_fetch_assoc() or mysql_fetch_array() ...

Q: is there a parameter built into it that can show what row you are on? (like a built in counter)...

also display just item # 7 for example:

<?php echo $row_test['id']; ?> ??? show just the 7th row???

[big_nerd]

coolcat,

There is an item in the PHP Manual that might help you.

Not only did this person post this on my Birthday (must be a sign) but it seems to do what you want.

<?php
function mysql_fetch_rowsarr($result, $numass=MYSQL_BOTH) {
  $got=array();
  mysql_data_seek($result, 0);
    while ($row = mysql_fetch_array($result, $numass)) {
        array_push($got, $row);
    }
  return $got;
}
?>

This will give you:

// Show the 7th row 'id'
<?php echo $row_test[7]['id']; ?> 

best of luck!

[big_nerd]

Sorry for bumping thread, but I forgot to mention,

// Show the 7th row 'id'
<?php echo $row_test[6]['id']; ?>

Arrays start at 0, not 1.

[coolcat]

Thanks big.nerd for the assist!