[SOLVED] how to view items in alphabetical order

[pixeltrace]

guys,

 

i need help, how can i view items in my database in alphabetical order?

SELECT COUNT(*) FROM #__brand_name ORDER by cat_name DESC

 

i tried this one but its not working.

 

hope you could help me with this.

 

thanks!

[suttercain]

Try

 

SELECT COUNT(*) FROM #__brand_name ORDER by cat_name DESC;

[mmarif4u]

What u get from ur query when u run it.

[genericnumber1]

why count?

 

SELECT * FROM #__brand_name ORDER by cat_name DESC

[pixeltrace]

its still the same.

 

the items are viewed this way

z

a

testing1

test

testing

 

its still not working.

 

how do i fix this?

[pixeltrace]

its working now.

 

thanks!

[mmarif4u]

Can u show us ur updated query.

[genericnumber1]

my guess would be

 

SELECT * FROM #__brand_name ORDER by cat_name ASC

[mmarif4u]

yes genericnumber1

ur query is right

 

bcoz asc is used from upper order like A to Z, but desc is used for lower order like

Z to A.

 

Select * right here, not select count(*).

count is mostly used for searching purpose.

[igor berger]

count(*) tells you how many records you have in your table.