UBB.Developers Forums Community Development Programming MySQL and Server Configuration sort by

hi all

This is not for threads but maybe you can help?

In my DB i have these colums:

sku | grp | title | price | image | description
1000
1003
1002
1004
1001

See my 'sku' numbers are all mixed up, is there a command I can use to sort the sku numbers in order?

Thanks again

You can't change that in the db, but you can sort it when doing a query.

Basically any queries in your code that you do against that table you'd just the bit below to the end of your query

ORDER BY sku

That would order them from lowest to highest sku. If you want it from highest to lowest you'd use:

ORDER BY sku DESC

Thanks for that reply, i'm a little lost: here is my query

<?php displaygroup ('SHRUBS'); ?>

Where should i place ORDER BY sku.

Thanks again!!!

DOH DOH I was in the wrong place!!! lol

$sql = 'select sku from products where grp="'.$groupname.'" order by sku asc';

THANKS Scream you fixed it!!!

Cheers!