$reponse = mysql_query("SELECT DISTINCT M.trivial_name,M.iupac_code, M.origin, T.label_type FROM molecule M, monosacch_family F,sugar_identifier SF,type T WHERE M.id_type=T.id_type AND M.id_molecule=SF.id_molecule AND SF.id_family=F.id_family ".$requete." ORDER BY M.trivial_name"); if(mysql_num_rows($reponse)==0)echo " No Oligosaccharide "; else echo"<table border ='1'><tr><th>Trivial name</th><th>IUPAC code</th><th>Origin</th><th>Type</th><th>Selection</th></tr>"; while($donnees= mysql_fetch_array($reponse)or die(mysql_error())) { echo "<tr ><td style='text-align:left;padding-left:10px;'>".$donnees['trivial_name']."</td><td style='text-align:left;padding-left:10px;'>".$donnees['iupac_code']."</td><td>".$donnees['origin']."</td><td>".$donnees['label_type']."</td>"; if(in_array($donnees['trivial_name'],$liste)){ echo "<td></td></tr>"; } else{ echo "<td></td></tr>"; } }
Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre question