SV: Sorting

[Martin Edelius]

Without knowing what your table looks like an "ORDER BY [column with
links in it] ASC" sounds like a good idea...


Best regards,
Martin Edelius

Spirex Digital Design

--------------------------------
www: http://www.spirex.se
Mail: martin.edelius@stripped
Phone: [phone]
Fax: [phone]
S-422 43 Hisings Backa
--------------------------------

-----Ursprungligt meddelande-----
Till: mysql@stripped <mysql@stripped>
Datum: den 3 augusti 1999 13:11


I would like to sort the results by item name ($IN) what would I do to
do that?

this is the PHP page im using....

mysql_connect("$DBHost","$DBUser","$DBPass");
@mysql_select_db( "endura" );
$result=mysql_query("SELECT * FROM Items WHERE Category='$CA'");

echo "Select an item:<br><br>";
echo "<ul>";

while ($row  =  mysql_fetch_row($result)) {
$II=$row[0];
$IN=$row[1];
$ID=$row[2];
$IC=$row[3];
$Ca=$row[4];

echo "$II - <a href='./description.php3?II=$II'>$IN</a> - $ID<br>";
        }
echo "</ul>";

I want these links sorted from A - Z....

echo "$II - <a href='./description.php3?II=$II'>$IN</a> - $ID<br>";

any help would be appreciated


Regards,

W. J. Samplonius
e n d u r a d e z i n e
info@stripped
www.endura.co.nz