> > > 1 'en' 'blue circle' 'this is a blue ' > > > 1 'no' 'bla cirkel' 'dette er ei bla cirkel' > > > 2 'en' 'green leaf' 'this is a green leaf from a tree' > > > 2 'sv' 'grönt löv' 'detta är ett grönt löv från ett träd' > > > > > > if the language priority is en,sv,no the "select"would return the following > > > 1 'en' 'blue circle' 'this is a blue ' > > > 2 'en' 'green leaf' 'this is a green leaf from a tree' > > > > > > if however the language prority was sv,no,en the select should return the > > > following > > > 1 'no' 'bla cirkel' 'dette er ei bla cirkel' > > > 2 'sv' 'grönt löv' 'detta är ett grönt löv från ett träd' > > =and if the requested language priority was sv, de, it would only: > 2 'sv' 'grönt löv' 'detta är ett grönt löv från ett träd' > be returned? > > =and if the requested language priority was fr, sp, it would nothing be returned?
well it might depend on the user, if it should NOt return any values or some default value that you must always insert your translations in.. for instance, defaultlanguage here might be norwegian, and normally everything should exist in norwegian and atleast it should display the "default" value so that the user will not just get empty data-rows or something like that.. If there exist 1 article it should always return 1 article... even if it is not translated to your prefered language. that is what I think anyway.. and that is how it is working here now... (without a cool single sql-query) /Christian Andersson --------------------------------------------------------------------- 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
