Re: Subquerries

MySQL don't support sub querries. See MySQL manual - 5.4.1 Sub-selects OB> Hi everybody OB> I use OB> * mysql-3.23.36-win OB> * apache_1.3.19-win32 OB> * php-4.0.4pl1-Win32 OB> On NT4 SP5 OB> I try this : OB> <CENTER><TABLE COLS=1 WIDTH="81%"> OB> <? OB> $operateur = " OR "; OB> $sub_query = ""; OB> $query_num_effet = "SELECT * FROM tr_scene_effet WHERE num_scene = $selScene ORDER BY OB> num_effet ASC "; OB> $result_num_effet = mysql_db_query( $db, $query_num_effet ); OB> while( $ligne_num_effet = mysql_fetch_array( $result_num_effet ) ) OB> { OB> $sub_query = $sub_query . " num_effet = " . $ligne_num_effet[ OB> "num_effet" ] . $operateur; OB> } OB> $sub_query = substr( $sub_query, 1, strlen( $sub_query ) - ( strlen( $operateur ) + 1 ) ); OB> $query_effet = "SELECT lib_effet FROM t_effet WHERE " . $sub_query; OB> $result_effet = mysql_db_query( $db, $query_effet ); OB> while( $ligne_effet = mysql_fetch_array( $result_effet ) ) OB> { ?>> OB> <TR> OB> <td background="/images/transp.gif"> OB> <LI> OB> <FONT><?echo $ligne_effet[ "lib_effet" OB> ];?></FONT></LI> OB> </TD> OB> </TR> OB> <? OB> } ?>> OB> </TABLE></CENTER> OB> that works. OB> Whereas : OB> <CENTER><TABLE COLS=1 WIDTH="81%"> OB> <? OB> $query_effet = "SELECT lib_effet FROM t_effet WHERE num_effet IN (SELECT num_effet FROM OB> TR_scene_effet WHERE num_scene = $selScene) " OB> $result_effet = mysql_db_query( $db, $query_effet ); OB> while( $ligne_effet = mysql_fetch_array( $result_effet ) ) OB> { ?>> OB> <TR> OB> <td background="/images/transp.gif"> OB> <LI> OB> <FONT><?echo $ligne_effet[ "lib_effet" OB> ];?></FONT></LI> OB> </TD> OB> </TR> OB> <? OB> } ?>> OB> </TABLE></CENTER> OB> doesn't work. OB> Does it mean I can't use sub querries ? OB> Anybody have an idea ? OB> Thanks, OB> Olivier. -- Best regards, Ruslan rus@bagan.da.ru