> > let say that the table (id,language,name,description) where id,language is > > the primary key so that 1 id can have several languages > > > > the data in the database looks like this > > > > 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? =dn --------------------------------------------------------------------- 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