[RESOLVED] Numbering rows

[netfrugal]

I have a simple query that shows all records of members:

<?
$sql = mysql_query("SELECT * FROM members ORDER BY members_lastname ASC");  

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

 ?>
              <tr>
                                <td>   </td>
				<td><?php echo $row['members_id']; ?></td>
				<td><?php echo $row['members_lastname']; ?></td>
                                <td><?php echo $row['members_firstname']; ?></td>
				<td><?php echo $row['members_email_address'];?> </td>
				<td><?php echo $row['members_telephone'];?> </td>

          </tr>
<?  } ?>

This is fairly simple, but how does one number the rows shown on the page?
You will see that I put the first row as emtpy. I've been having problems finding a simple way to number the results shown from 1 - whatever.

Does the actual query string need to be changed? Or can it be a separate query?

thanks!

[laserlight]

One way is to change the while loop into a for loop:

for ($i = 0; $row = mysql_fetch_array($sql); ++$i) {

Then in the loop body, you calculate for some integer n (5, in this case):
$offset = $i * n;

From there you can number with: $offset + 1, $offset + 2, ..., $offset + n.

[netfrugal]

I can see how you would change the while to a for loop, but I'm confused how to actually place it inside the html.

And what do you mean when you say:

"you calculate for some integer n (5, in this case):
$offset = $i * n;"

What does 5 have to do with it?

thanks!

[laserlight]

Oh, sorry, I misread your HTML. In this case, you can disregard the computation. Instead, loop with:

for ($i = 1; $row = mysql_fetch_array($sql); ++$i) {

Now, $i is your row number.

EDIT:
To be fair, I was misled by your claim that you "put the first row as emtpy". You actually put the first column (or cell, as the case may be) as empty :p

[netfrugal]

That worked, and it made sense too! thanks a ton!