List:General Discussion« Previous MessageNext Message »
From:Martin Edelius Date:August 3 1999 11:26am
Subject:SV: Sorting
View as plain text  
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: +46-31-514651, 0708-113711
Fax: +46-31-514331
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




Thread
SV: SortingMartin Edelius3 Aug
  • Re: SortingJody3 Aug
  • Re: SortingChristian Mack3 Aug