[Leipe_Po]

can somebody pleas tell me how to do that? whats the trick?
i need to order something on a alfabetical order like so:

a - b - c - d ect. ect

and when they click on the a the mysql database spits out all the titles that begin with an a and so on...

thanx alot,

Leipe_Po

[blaw]

Hello,

You can use yourField LIKE 'x%' in your WHERE clause, where "x" replaces the character that the user has clicked on. e.g. to get all records whose "state" field begins with "s", use state LIKE 's%' .

Now you can pass an alphabetic letter via HTTP request (GET, POST, etc) when a user clicks on it and insert this letter into your SQL (i.e. "x" in the above example) to retrieve the corresponding data.

For more info on LIKE, I suggest that you consult with MySQL documentation:

http://dev.mysql.com/doc/mysql/en/st...functions.html

Hope this helps. =)

[Leipe_Po]

i will try it out tonight, thanx for the info mate, will let you know if it works!

[FiRe]

or just in the query:

ORDER BY name

that will order words in the name field in alphabetical order! for example:

mysql_query("SELECT name, email, userid FROM users ORDER BY name");