Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre question$query_Recordset1 = "SELECT mot FROM ep_mot1"; $Recordset1 = mysql_query($query_Recordset1, $mysql_link) or die(mysql_error()); $row_Recordset1 = mysql_fetch_assoc($Recordset1); $totalRows_Recordset1 = mysql_num_rows($Recordset1); $list1= $row_Recordset1['mot']; $query_Recordset2 = "SELECT mot FROM ep_mot2"; $Recordset2 = mysql_query($query_Recordset2, $mysql_link) or die(mysql_error()); $row_Recordset2 = mysql_fetch_assoc($Recordset2); $totalRows_Recordset2 = mysql_num_rows($Recordset2); $list2= $row_Recordset2['mot'];
$query_Recordset1 = "SELECT * FROM ep_mot1 WHERE mot"; $Recordset1 = mysql_query($query_Recordset1, $mysql_link) or die(mysql_error()); $row_Recordset1 = mysql_fetch_assoc($Recordset1); $totalRows_Recordset1 = mysql_num_rows($Recordset1); $list1= $row_Recordset1['mot']; $query_Recordset2 = "SELECT * FROM ep_mot2 WHERE mot"; $Recordset2 = mysql_query($query_Recordset2, $mysql_link) or die(mysql_error()); $row_Recordset2 = mysql_fetch_assoc($Recordset2); $totalRows_Recordset2 = mysql_num_rows($Recordset2); $list2= $row_Recordset2['mot'];
<?php // J'ai deux liste de mots séparés pas des virgules $mesmots1 = "banane,pomme,poire,orange"; $mesmots2 = "ananas,banane,peche,poire"; // Je met les mots dans un tableau en indiquant qu'il faut prendre en compte la virgule pour créer les lignes $maliste1 = explode(',', $mesmots1); $maliste2 = explode(',', $mesmots2); /* Ca me donne ces deux tableaux : maliste1 Array ( [0] => banane [1] => pomme [2] => poire [3] => orange ) maliste2 Array ( [0] => ananas [1] => banane [2] => peche [3] => poire ) */ $malistefin = array_intersect($maliste1, $maliste2); /* Ca me donne ce tableau : malistefin Array ( [0] => banane [1] => poire ) */ $mesmotsfin = implode(',', $malistefin); echo $mesmotsfin; // banane,poire ?>
$query_Recordset1 = "SELECT mot FROM ep_mot1"; $Recordset1 = mysql_query($query_Recordset1, $mysql_link) or die(mysql_error()); $row_Recordset1 = mysql_fetch_assoc($Recordset1); $totalRows_Recordset1 = mysql_num_rows($Recordset1); $list1= $row_Recordset1['mot'];
// les mots dans les tableau qu'il faut prendre $maliste1 = $list1; $maliste2 = $list2; /* Ca me donne ces deux tableaux : maliste1 Array ( [0] => banane [1] => pomme [2] => poire [3] => orange ) maliste2 Array ( [0] => ananas [1] => banane [2] => peche [3] => poire ) */ $malistefin = array_intersect($maliste1, $maliste2); /* Ca me donne ce tableau : malistefin Array ( [0] => banane [1] => poire ) */ $mesmotsfin = implode($malistefin);
$query_Recordset1 = "SELECT * FROM ep_mot WHERE mot ='$mot'"; $Recordset1 = mysql_query($query_Recordset1, $mysql_link) or die(mysql_error()); $row_Recordset1 = mysql_fetch_assoc($Recordset1); $totalRows_Recordset1 = mysql_num_rows($Recordset1); $list1= $row_Recordset1['mot'];