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