มีวิธี SELECT จาก Database เพื่อจะกำหนด ลำดับ ของ row นั้นๆไหมครับ ให้มันนับ 1 , 2 , 3 ไปเรื่อยๆ

$sql = "SELECT ..........";

$query = mysql_query($sql);
$array = array();
while( $result = mysql_fetch_array( $query )  ){

    $array[$result["wd_by"]] = 1 + $array[$result["wd_by"]];

    echo "งวดที่ ".$array[$result["wd_by"]];
}

<meta http-equiv="Content-Type" content="text/html; charset=windows-874" />
<LINK rel="stylesheet" type="text/css" href="badminton/style.css">
<?PHP
	mysql_connect('localhost','user','1234') or die("ติดต่อ Host ไม่ได้");
	mysql_select_db('class') or die("ติดต่อฐานข้อมูลไม่ได้");
	mysql_query("SET character_set_results=tis620");
	mysql_query("SET character_set_client='tis620'");
	mysql_query("SET character_set_connection='tis620'");
	mysql_query("collation_connection = tis620_thai_ci");
	mysql_query("collation_database = tis620_thai_ci");
			//สร้างตาราง	
				print "<table class=simply>";
				print "<tr>";
				print "<th align = center width = 150>คนที่</th>";
				print "<th align = center width = 150 >เงินยืม</th>";
				print "<th align = center width = 150 >งวดที่</th>";
				print "</tr>";

$sqlData = "select * from test order by wd asc" ;
$sqlqueryData=mysql_db_query('class', $sqlData);
//กำหนด ค่า n เอาไปใช้เทียบกับค่า count
$n = 1;
while($rsData = mysql_fetch_array($sqlqueryData))		
		{

				print "<tr>";
				print "<td height=35 align = center>".$rsData['wd']." </td>";
				print "<td height=35 align = center>".$rsData['am']." </td>";
				$sql01 = "SELECT COUNT(wd) AS q FROM test WHERE wd=".$rsData['wd']."";
				$sqlquery01=mysql_db_query('class', $sql01);
				while($rs01 = mysql_fetch_array($sqlquery01))


					{
				$k = $rs01['q'];
				//print "<td height=35 align = center>".$k." </td>";
					if($n <= $k){		
				print "<td height=35 align = center>".$n." </td>";
						$n ++;
					if($n>$k)
									{		
											$n = 1;
						}}}
				print "</tr>";
}
print"</table>";
?>

-- phpMyAdmin SQL Dump
-- version 2.10.3
-- http://www.phpmyadmin.net
-- 
-- Host: localhost
-- Generation Time: Jul 26, 2012 at 12:33 PM
-- Server version: 5.0.51
-- PHP Version: 5.2.6

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

-- 
-- Database: `class`
-- 

-- --------------------------------------------------------

-- 
-- Table structure for table `test`
-- 

CREATE TABLE `test` (
  `id` int(2) NOT NULL auto_increment,
  `wd` int(4) NOT NULL,
  `am` int(9) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=tis620 AUTO_INCREMENT=13 ;

-- 
-- Dumping data for table `test`
-- 

INSERT INTO `test` VALUES (1, 1, 5000);
INSERT INTO `test` VALUES (2, 1, 1200);
INSERT INTO `test` VALUES (3, 1, 2500);
INSERT INTO `test` VALUES (4, 1, 2000);
INSERT INTO `test` VALUES (5, 2, 2000);
INSERT INTO `test` VALUES (6, 1, 200);
INSERT INTO `test` VALUES (7, 3, 3000);
INSERT INTO `test` VALUES (8, 2, 2500);
INSERT INTO `test` VALUES (9, 2, 800);
INSERT INTO `test` VALUES (10, 4, 900);
INSERT INTO `test` VALUES (11, 2, 500);
INSERT INTO `test` VALUES (12, 3, 100);