$extraRequete = "SELECT planet.plId FROM planet WHERE plType = 1 OR plType = 2 OR plType = 4 OR plType = 6 OR plType = 7 OR plType=8";
$nbPlanet = mysql_num_rows(mysql_query($extraRequete));
?>
| echo str_replace(" "," ",$lg_catalog_catNum0); ?> |
|
echo $nbPlanet." ".$lg_catalog_pl; ?> |
|
| |
|
$extraRequete = "SELECT planet.plId FROM planet WHERE plType=1 OR plType=7 OR plType=8";
$nbPlanet = mysql_num_rows(mysql_query($extraRequete));
$extraRequete = "SELECT distinct(pl1.plStar) FROM planet AS pl1, planet AS pl2 WHERE pl1.plStar = pl2.plStar AND pl1.plName <> pl2.plName AND ((pl1.plType = 1 AND pl2.plType = 1) OR (pl1.plType = 7 AND pl2.plType = 7) OR (pl1.plType = 8 AND pl2.plType = 8))";
$nbMultiPlanet = mysql_num_rows(mysql_query($extraRequete));
$extraRequete = "select distinct(plStar) from planet WHERE plType=1 or plType=7 or plType=8";
$nbPlSyst = mysql_num_rows(mysql_query($extraRequete));
$result = mysql_query ("select max(planet.plUpdate) as maxDate from planet where plType=1 or plType=7 or plType=8");
?>
 |
 |
echo str_replace(" "," ",$lg_catalog_catNum1); ?> |
|
echo $nbPlSyst." ".$lg_catalog_plSys ?> |
 |
| |
|
echo $lg_rec_maj." ".date_user_multiLg(mysql_result($result,0,'maxDate'),$moisLang); ?> |
|
echo $nbPlanet." ".$lg_catalog_pl ?> |
| |
|
|
|
echo $nbMultiPlanet." ".$lg_catalog_multiPlSys ?> |
| |
|
$extraRequete = "SELECT planet.plId FROM planet WHERE plType = 7";
$nbPlanet = mysql_num_rows(mysql_query($extraRequete));
// Nb de systemes multiplanetes ayant au moins une planete de type 7 (en transit)
$extraRequete = "SELECT distinct(pl1.plStar) FROM planet AS pl1, planet AS pl2 WHERE pl1.plStar = pl2.plStar AND pl1.plName <> pl2.plName AND (pl1.plType = 7 OR pl2.plType = 7)";
$nbMultiPlanet = mysql_num_rows(mysql_query($extraRequete));
$extraRequete = "select distinct(plStar) from planet WHERE plType = 7";
$nbPlSyst = mysql_num_rows(mysql_query($extraRequete));
$result = mysql_query ("select max(planet.plUpdate) as maxDate from planet where plType = 7");
?>
| |
|
echo str_replace(" "," ",$lg_catalog_catNum8); ?> |
|
echo $nbPlSyst." ".$lg_catalog_plSys ?> |
| |
|
echo $lg_rec_maj." ".date_user_multiLg(mysql_result($result,0,'maxDate'),$moisLang); ?> |
|
echo $nbPlanet." ".$lg_catalog_pl ?> |
| |
|
|
|
echo $nbMultiPlanet." ".$lg_catalog_multiPlSys ?> |
| |
$extraRequete = "SELECT planet.plId FROM planet WHERE plType = 4";
$nbPlanet = mysql_num_rows(mysql_query($extraRequete));
$extraRequete = "SELECT distinct(pl1.plStar) FROM planet AS pl1, planet AS pl2 WHERE pl1.plStar = pl2.plStar AND pl1.plName <> pl2.plName AND pl1.plType = 4 AND pl2.plType = 4";
$nbMultiPlanet = mysql_num_rows(mysql_query($extraRequete));
$extraRequete = "select distinct(plStar) from planet WHERE plType = 4";
$nbPlSyst = mysql_num_rows(mysql_query($extraRequete));
$result = mysql_query ("select max(planet.plUpdate) as maxDate from planet where plType = 4");
?>
 |
 |
echo str_replace(" "," ",$lg_catalog_catNum2); ?> |
|
echo $nbPlSyst." ".$lg_catalog_plSys ?> |
 |
| |
|
echo $lg_rec_maj." ".date_user_multiLg(mysql_result($result,0,'maxDate'),$moisLang); ?> |
|
echo $nbPlanet; ?> echo $lg_catalog_pl ?> |
| |
|
|
|
echo $nbMultiPlanet." ".$lg_catalog_multiPlSys ?> |
| |
$extraRequete = "SELECT planet.plId FROM planet WHERE plType = 6";
$nbPlanet = mysql_num_rows(mysql_query($extraRequete));
$extraRequete = "SELECT distinct(pl1.plStar) FROM planet AS pl1, planet AS pl2 WHERE pl1.plStar = pl2.plStar AND pl1.plName <> pl2.plName AND pl1.plType = 6 AND pl2.plType = 6";
$nbMultiPlanet = mysql_num_rows(mysql_query($extraRequete));
$extraRequete = "select distinct(plStar) from planet WHERE plType = 6";
$nbPlSyst = mysql_num_rows(mysql_query($extraRequete));
$result = mysql_query ("select max(planet.plUpdate) as maxDate from planet where plType = 6");
?>
 |
 |
echo str_replace(" "," ",$lg_catalog_catNum3); ?> |
|
echo $nbPlSyst." ".$lg_catalog_plSys ?> |
 |
| |
|
echo $lg_rec_maj." ".date_user_multiLg(mysql_result($result,0,'maxDate'),$moisLang); ?> |
|
echo $nbPlanet." ".$lg_catalog_pl ?> |
| |
|
|
|
echo $nbMultiPlanet." ".$lg_catalog_multiPlSys ?> |
| |
$extraRequete = "SELECT planet.plId FROM planet WHERE plType = 2";
$nbPlanet = mysql_num_rows(mysql_query($extraRequete));
$extraRequete = "SELECT distinct(pl1.plStar) FROM planet AS pl1, planet AS pl2 WHERE pl1.plStar = pl2.plStar AND pl1.plName <> pl2.plName AND pl1.plType = 2 AND pl2.plType = 2";
$nbMultiPlanet = mysql_num_rows(mysql_query($extraRequete));
$extraRequete = "select distinct(plStar) from planet WHERE plType = 2";
$nbPlSyst = mysql_num_rows(mysql_query($extraRequete));
$result = mysql_query ("select max(planet.plUpdate) as maxDate from planet where plType = 2");
?>
|
|
echo str_replace(" "," ",$lg_catalog_catNum4); ?> |
|
echo $nbPlSyst." ".$lg_catalog_plSys ?> |
 |
| |
|
echo $lg_rec_maj." ".date_user_multiLg(mysql_result($result,0,'maxDate'),$moisLang); ?> |
|
echo $nbPlanet." ".$lg_catalog_pl ?> |
| |
|
|
|
echo $nbMultiPlanet." ".$lg_catalog_multiPlSys ?>
|
| |