Hi all, I d like to order some links which are in 2 langauage (French/English).
So i make this request in case a visitor select french in language so french links where on top in this case because "f"rench is after "e"nglish in alphabectical order. SELECT * FROM links WHERE Accepter LIKE 1 AND CatID LIKE 43 ORDER BY language DESC,Linkname ASC; And for english selection I make this. SELECT * FROM links WHERE Accepter LIKE 1 AND CatID LIKE 43 ORDER BY language ASC,Linkname ASC; If I like to introduce german by example, what kind of query i have to do to put french links on top asc->english desc->german. french ? Is there any way to put a sort order different than the alpahbetical order in string. A thing like that order "french","german" .... Thanks. query sql mysql _________________________________________________________ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
