Re: [PHP-DB] Re: Subselect ?

2004-01-16 Thread Martin Marques
Mensaje citado por Christine Clerc <[EMAIL PROTECTED]>: > Well, I had tried this : > SELECT DISTINCT id_script FROM readme WHERE id_language = $languageorignin; > But then I have to do this with the selection : > SELECT DISTINCT id_script FROM readme WHERE id_language != $languagetarget; > but it

Re: [PHP-DB] Re: Subselect ?

2004-01-16 Thread Christine Clerc
Well, I had tried this : SELECT DISTINCT id_script FROM readme WHERE id_language = $languageorignin; But then I have to do this with the selection : SELECT DISTINCT id_script FROM readme WHERE id_language != $languagetarget; but it cannot work since I get back the id_script from the first selection

Re: [PHP-DB] Re: Subselect ?

2004-01-16 Thread "Alban Médici (NetCentrex)"
try this SELECT DISTINCT id-script FROM YOURTABLE where id_language = 'SELECTED LANGUAGE' ; no ? Justin Patrin wrote: Christine Clerc wrote: Hi, I have a Mysql table of texts in different languages : id_readme id_script (the object that the text describes) id_language (the language the text i

[PHP-DB] Re: Subselect ?

2004-01-16 Thread Justin Patrin
Christine Clerc wrote: Hi, I have a Mysql table of texts in different languages : id_readme id_script (the object that the text describes) id_language (the language the text is written in) etc. So two texts may have the same id_script but with different id_language. I need to retrieve the list (