sorte by field

hi, I want to sort a table from a field.
that field as numbers and if the number is higher the field becomes the first.

how can I do this?
thanks

rtfm 😃

i've sort by doing this

SELECT *
FROM `table`
ORDER BY `field` DESC
LIMIT 0 , 30

however when I select the first field with php it keeps selecting the same field and not the sorted one...

thanks for any help

Hang on, there might be sticks being handled by wrong ends here.

Say your table has these 'fields'

id - name - surname

And you're sorting on surname, when you pull out a row with mysql_fetch_row, or mysql_fetch_array, are you expecting

$row[0] to be surname? That won't be the case unless you specify the order like

SELECT surname, name, id FROM table ORDER BY surname DESC;

strange..i'm doing something wrong

doing that I've sort the table.

But when I call it with mysql_fetch_row, or mysql_fetch_array ( row[0] ), it prints the first field before i've sorted (the table)

what can I do..thanks

Post your code (remember the php tags) as what you're saying is just confusing at the moment.

my code is:

$result = mysql_query("SELECT equipa FROM users");
$users = array();
while ($column = mysql_fetch_assoc($result)) $users[] = $column["equipa"];

and then

print $users[1];

Is there any reason that you're not printing $users[0]. You've done 60 posts so I assume you know arrays start at index zero.

😃
no there is no reason in printing array [0] or [1]

The real question is how can I sort the table.

I sort the table with SQL syntax (and it become sort), but when I leave and see another time the table it's not sorted

Well if equipa is the only thing you're selecting, and you want to sort by that, then

SELECT equipa FROm users ORDER BY equipa

Will be fine, or ORDER BY equipa DESC if you want it ordered in reverse.