create array from while loop

[prostcode]

PHP Code:

$query = "SELECT * FROM table";
$result = mysql_query($query);

   while($rows = mysql_fetch_array($result)){
       $code=$rows['code'];
       $pt=$rows['points'];
       $code_array = array($code);

       foreach($code_array as $key => $value) {
           echo $key. " " . $value . "<br>";
       }

   } 


instead the output is:

PHP Code:

0 Code1
0 Code2
0 Code3
0 Code4
0 Code5 


I want the output to be:

PHP Code:

0 Code1
1 Code2
2 Code3
3 Code4
4 Code5 


[StupidRalph]

PHP Code:

$query = "SELECT * FROM table";
$result = mysql_query($query);
$code_array = array();

   while($rows = mysql_fetch_array($result)){
       $code=$rows['code'];
       $pt=$rows['points'];
       $code_array[] = $code;

       foreach($code_array as $key => $value) {
           echo $key. " " . $value . "<br>";
       }

   } 


Try this instead...I have not tested it...

[prostcode]

Originally Posted by StupidRalph

PHP Code:

$query = "SELECT * FROM table";
$result = mysql_query($query);
$code_array = array();

   while($rows = mysql_fetch_array($result)){
       $code=$rows['code'];
       $pt=$rows['points'];
       $code_array[] = $code;

       foreach($code_array as $key => $value) {
           echo $key. " " . $value . "<br>";
       }

   } 


Try this instead...I have not tested it...

thanks. it works this time but the output looks weird

PHP Code:

0 Code1
0 Code1
1 Code2
2 Code3
3 Code4
0 Code5
0 Code5 


How? Actually I want to do sorting. I want to get the duplicate values to do some comparison. Do you know how?

[StupidRalph]

PHP Code:

$query = "SELECT * FROM table";
$result = mysql_query($query);
$code_array = array();

   while($rows = mysql_fetch_array($result)){
       $code=$rows['code'];
       $pt=$rows['points'];
       $code_array[] = $code;       
   }  

foreach($code_array as $key => $value) {
           echo $key. " " . $value . "<br>";
       } 


Pull the foreach out of the while loop. PHP has a lot of different sort functions. Consult the php manual