number column sorting help

[michaelowen]

hello!

i am extensively sorting data from my table, and need to create a new column that will number the results depending on the number of returned rows.

what is the most efficient loop to do this?

for example, if my sort only shows 4 results:

1. sorted outcome
2. sorted outcome
3. sorted outcome
4. sorted outcome

---

thanks,
-michael

[michaelowen]

i put this together, but i can't figure out a field name that will mean "all returned rows".

where would i add this loop into this display script i wrote so that it will look like the results are numbered?

something like this look ok?

---

echo "<table width=100% border=0>";
$run_query = "SELECT * FROM table order by risp_place, last_name ";
$run_result = mysql_query($run_query);
echo "<tr><td><center><font size=+2 color=red>2004 pRIx Standings: </font></center></td></tr>";
echo "<tr><td></td></tr>";
echo "<tr><td></td></tr>";
echo "<tr><td><b>Name </b> </td><td><b>Sex</b></td><td><b>Age</b></td><td><b>City</b></td><td><b>State</b></td><td><b>Team</b></td><td><b>RISP5k Place</b></td></tr>";
$i=0;
while($run_row = mysql_fetch_array($run_result)){
$mydatarunorder = $run_row[????]; //THIS FIELD IS MY QUESTION
$mydatarunfirst = $run_row['first_name'];
$mydatarunlast = $run_row['last_name'];
$mydatarunsex = $run_row['sex'];
$mydatarunage = $run_row['age'];
$mydataruncity = $run_row['city'];
$mydatarunstate = $run_row['state'];
$mydatarunteam = $run_row['team'];
echo "<tr><td>echo "$row[user] - $i\n";</td><td>".$mydatarunfirst. "&nbsp" .$mydatarunlast."</td><td>".$mydatarunsex."</td><td>".$mydatarunage."</td><td>".$mydataruncity."</td><td>".$mydatarunstate."</td><td>".$mydatarunteam."</td></tr>";
$i++;
}
echo "</table>"

---

thanks,

-michael

[dnast]

Maybe I'm misunderstanding, but it looks like your $i is already giving the row number, although the echo statement is a little off.

echo "<tr><td>".$i.".</td> <td>".$mydatarunfirst. "&nbsp" .$mydatarunlast."</td> <td>".$mydatarunsex."</td> <td>".$mydatarunage."</td> <td>".$mydataruncity."</td> <td>".$mydatarunstate."</td> <td>".$mydatarunteam."</td></tr>";

[Weedpacket]

It's probably tidier to use a for() loop than trying to build one by hand out of a while() loop...

 $run_result = mysql_query($run_query); 
//...
$run_row_count = mysql_num_rows($run_result);
for($i=1; $i<=$run_row_count; $i++)
{
  $run_row = mysql_fetch_array($run_result);
 $mydatarunfirst = $run_row['first_name']; 
....
}

And as dnast noted, $i can be used to number the rows.