numbering rows

[Anon]

how do I return sequentual numbering for rows? I have alternating rows that I want to put a number in the first column. can't use the auto_increment field from the dbase as it would not be sequential with my select statement.

How can this be done? I have attempted the following in my while statement:

$i = 1;
$RowColor = useColor();
print "<TR bgcolor=\"$RowColor\"><TD>$i</TD><TD>$email</TD><TD>$IP</TD><TD>$dtinfo</TD></TR>";
$i++;
}

thanks,
john

[Anon]

If you want to alternate the bgcolor, just use a var to altertnate it:

$var = 0;

while (do for every row)
{

$var=1-$var;

if ($var==1)
{
$bgcolor="black";
}
else
{
$bgcolor="white";
};

print "<TR><TD bgcolor=".$bgcolor.">blabla";

}

[Anon]

I think you need to have the inital $i = 1;
before the start of the while statement, other than that it should work. The way you have it now, it keeps setting $i = 1; everytime it runs

[Anon]

that worked!! thank you, just had to move the location of $i = 1;

thanks,
john

[Anon]

that works, but it lists the rows in descending order. I want the most recent input to be at the top so I sort by date in my select statement. now, I want the numbers to go in descending order, thus if there are six rows then number six will be at the top.

most recent will have highest number value.

How can I accomplish this with the above code? Or any code for that matter.

TIA,
john

[Anon]

Who interesting, I think this may work:

$result = mysql_query("SELECT.....");

$count = mysql_num_rows($result);

$i = $count;

while ($row=mysql_fetch_array($result)) {
print ......
$i = $i -1;
}

[Anon]

that did work! thanks, I came up with this same thing though my count statment wasn't so clean.

thanks louie!!

john