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 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[ "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" ];?></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 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" ];?></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
[EMAIL PROTECTED]
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
