<?php

$sql = "SELECT * FROM table WHERE champ LIKE '%toto%'";

?>

<?php

						 	$chaine = $row["pinyin"];

							$tok = strtok($chaine, " \n\t");

							while ($tok !== false) 

								{	echo '<tr>';

  									$sql = "SELECT * FROM sinogrammes WHERE pinyin LIKE '%$tok%' ";



									$requete = mysql_query($sql) or die('Erreur SQL !<br />'.$sql.'<br />'.mysql_error());

									// on va scanner tous les tuples un par un

									while ($data = mysql_fetch_array($requete)) 

										{	// on affiche les résultats

											echo '<td><a href="../sinogrammes/fiche.php?id='.$data['id'].'" alt="'.$data['mandarin'].'" >'.$data['traditionnel'].'</a></td>';

											echo '<td>'.$data['mandarin'].'</td>';											

											echo '<td>'.$data['traduction'].'</td>';						

										}

									mysql_free_result ($requete);			

									$tok = strtok(" \n\t");

								}

							mysql_close ();

							echo '<tr>';

						?>