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

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_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)) {

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


W. J. Samplonius
e n d u r a d e z i n e

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