[Resolved] sort an array

[moboter]

I want to use the following code to sort the results by the values found at [1] from my table something seems to be wrong though.

$sql_1[]= mysql_query(" SELECT * FROM artikel1 ORDER BY   Bezeichnung ASC");
sort($sql_1 ASC,[1]);

Shouldnt this store all the values in the variables?
I want to reference the values with
Description<input name='name' type='text' maxlength='20' value='sql_1[1]'>

[tekky]

Nooo...

$result = mysql_query(" SELECT * FROM artikel1 ORDER BY Bezeichnung ASC"); 
//that takes care of the sorting....
while($row = mysql_fetch_array($result))
{

   echo '<hr><br><pre>';
   print_r($row);
  echo '</pre><br>';
}

this will loop through the results your query returns and print out ALL columns... from each row....