Re: [PHP-DB] Sorting the result

2002-02-28 Thread Kristjan Kanarik
On Wed, 27 Feb 2002, William Fong wrote: $article_query = mysql_query(select article_name, article_text from articles where article_name LIKE '%$q%' ORDER BY $q_count DESC ) or die (mysql_error()); Put the ORDER BY $q_count DESC in your SQL statement and that will make MySQL do the

Re: [PHP-DB] Sorting the result

2002-02-27 Thread William Fong
$article_query = mysql_query(select article_name, article_text from articles where article_name LIKE '%$q%' ORDER BY $q_count DESC ) or die (mysql_error()); Put the ORDER BY $q_count DESC in your SQL statement and that will make MySQL do the sorting for you. PHP will get it already sorted.