RE: [PHP-WIN] ORDER BY is not sorting

Hi! I can't see anything with your code either. Mysql_fetch_array should work fine yes. No indexes are needed to sort fields, but are recommended for speeding up the process :-) How does the table users look like? (Please send a link to a screenshot or something like that) Sometimes I have noticed that PHP isn't that good of getting right results when using $variable inside ""-chars You could try doing this: $table_name ='users'; // Select records $result = mysql_query("SELECT * FROM " . $table_name . " ORDER BY rowID DESC"); // Loop through the record set while($row = mysql_fetch_array($result)) print 'rowID =' .$row['rowID']. '<br />' There might be some issues regarding permissons of MySQL. Have you tried doing another sql-select statement on another table? Best regards /Gustav Wiberg -----Original Message----- From: Mark Abrams [mailto:mark@hospitalsystemsgroup.com] Sent: Wednesday, August 01, 2007 12:50 AM To: php-windows@lists.php.net Subject: Re: [PHP-WIN] ORDER BY is not sorting Is mysql_fetch_array the proper function to access sorted data? The problem is consistent on my test server and my ISPs mySQL DB. rowID is the primary key. Do I need to have an index attribute on a field I want to sort? <tg-php@gryffyndevelopment.com> wrote in message news:20070731203155.CEE1819504F@spaceymail-a3.g.dreamhost.com... >I can't really see anything wrong with what you have there. It shouldn't >matter that your SQL is inside the query function, although I like to build >the query in a variable outside the query function, but either way it >should work. > > And you're obviously getting data and not an error, right? > > What happens if you leave the "DESC" off? Does it come back 4, 3, 2, 1? > or still 1, 2, 3, 4? > > You might try displaying more data from the result set to see if there's > some other issue. > > And have you tested the SQL statement just using MySQL via command line, > phpMyAdmin, WinSQL, Navicat, or something like that? > > -TG > > = = = Original message = = = > > Sorry, this seams very trivial but I can not sort the result set for any > field. What am I doing wrong? > > > php & mySQL 5 > > > <?php > > ... > > $table_name ='users'; > > // Select records > $result = mysql_query("SELECT * FROM $table_name ORDER BY rowID DESC"); > > > // Loop through the record set > while($row = mysql_fetch_array($result)) > print 'rowID =' .$row['rowID']. '<br />' > > > ?> > > 1 > 2 > 3 > 4 > > > TIA > Mark > > -- > PHP Windows Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > > ___________________________________________________________ > Sent by ePrompter, the premier email notification software. > Free download at http://www.ePrompter.com. -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.5.476 / Virus Database: 269.11.0/927 - Release Date: 2007-07-30 17:02