Gustav Wiberg wrote:
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
what do you mean by that??? You mean PHP is having trouble getting
'right results' from a mysql database if _somewhere_ in the code there's
an interpolated string? Sounds a bit iffy to me...
- Tul
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@xxxxxxxxxxxxxxxxxxxxxxxx]
Sent: Wednesday, August 01, 2007 12:50 AM
To: php-windows@xxxxxxxxxxxxx
Subject: Re: 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@xxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:20070731203155.CEE1819504F@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
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