Adding a counter to a while loop

joice

I have a page on which I want to print all the values in my database table. To make it a bit more readable, I want to add a counter in front of each record. The code I have until now is like this:

while (($row = mysql_fetch_row($result)) AND ($result > 0))
echo"$row[1] - $row[2] - $row[3]<BR>";
mysql_close($connection);

Now I thought that adding a counter here would go something like this:

$i=1;
while (($row = mysql_fetch_row($result)) AND ($result > 0))
echo"$i - $row[1] - $row[2] - $row[3]<BR>";
$i++;
mysql_close($connection);

But what I get to see is:
1 - xxxx- yyyy - zzzz
1 - aaaa - bbb- cccc
1 - dddd - eee - ffff

It looks like the counter is always 1, even though I thought I raised it by one??

swallace

Your while loop is going to do the first statement after it if you don't have the {...} brackets there to say add 1 to i.

joice

Ehm, I am not sure if I understand what you mean... could you write down the code here, please?? Thanks!

Joyce

swallace

Sorry! :p

$i=1;
while (($row = mysql_fetch_row($result)) AND ($result > 0))
{
echo"$i - $row[1] - $row[2] - $row[3]<BR>";
$i++;
}
mysql_close($connection);

This means that the while statement will carry out the statements within the {}. Before your code only carried out the statement that printed out the result and not the incrementing of $i.

Good Luck

kula

I think you need to change mysql query .
I have assumed that one of your database variable is called “name”

Sqlquery = “select name, count(*) as count from vendors group by name;”

Good luck

joice

swallace, that was the solution, it works now, so cheers!!

Joyce