Mysql result sorting

tombo

I need some help building a query that will sort a result alphabetacly. I want the user to be able to press a link from a list like : abcdefghijklmnopqrstuvw....... And get the result sorted by title / name with the letter linked in the first position.

Like if he clicked on the "b" he would get a list like:

babes on ice
baby got back
ba
bb
bc
california man
charlies angels
cool runnings
d
e
f

Was a little hard to explain, but i hope you understood

🙂

Any help appreciated.

Thanks

Tom

LordShryku

Just build your queries with LIKE (LIKE a%. LIKE b%...)

superwormy

Sorting in MySQL is done with the ORDER BY clause. You should read the manual for more information on ORDER BY.

SELECT fieldname1, fieldname2 FROM tablename WHERE ( ... ) ORDER BY field_you_want_to_order_by

Not sure what LordShryku was talking about...

cgraz

He wants all the queries int he db that start with an 'A' for example, or start with a 'B'

Then, he can order them alphabetically using ORDER BY

SELECT * FROM table WHERE field_name LIKE 'a%' ORDER by field_name (I can't remember if it orders them automatically or not).

so % is the wildcard

will bring back anything that starts with an a

z% will bring back anything that starts with a b

Cgraz

LordShryku

Originally posted by cgraz
z% will bring back anything that starts with a b

Really? :p

superwormy

Ah my misunderstanding didn't read enough.

Thats a bit harder, I think what I'd do then is make an array of the alphabet to loop through and build my query with.

$alpha = array (
0 => "a",
1 => "b",
2 => "c",
etc.

Find the letter the person chose, say they chose K, then loop through the array STARTING at letter K ( use array_search() to locate it ) to make a query like this:

SELECT * FROM talbe WHERE name LIKE 'k%' OR name LIKE 'l%' OR name LIKE 'm%' OR name LIKE '%n' OR ... ORDER BY name

cgraz

Originally posted by LordShryku
Really? :p

lol you smartass. You know what I meant...:mad:

Cgraz

LordShryku

Couldn't resist 🙂