<div dir="ltr"><div class="gmail_default"><font face="times new roman, serif" size="4">I have a problem between MySQL and PHP...</font></div><div class="gmail_default"><font face="times new roman, serif" size="4">When I try this in MySQL :</font></div><div class="gmail_default"><font face="times new roman, serif" size="4">SELECT * FROM SJH JOIN sjhliaison ON ( <a href="http://SJH.ID">SJH.ID</a> = sjhliaison.PID AND sjhliaison.Tlid ='$Tid' ) WHERE sjhFrancais LIKE '$item%'</font><br></div><div class="gmail_default"><font face="times new roman, serif" size="4"><br></font></div><div class="gmail_default"><font face="times new roman, serif" size="4">puting '28' for $Tid and 'osier' in place of $item :</font></div><div class="gmail_default"><span class="gmail-syntax_alpha gmail-syntax_alpha_reservedWord" style="color:rgb(153,0,153);text-transform:uppercase;font-weight:bold;font-family:sans-serif;font-size:7.872px;background-color:rgb(229,229,229)">SELECT</span><span style="color:rgb(0,0,0);font-family:sans-serif;font-size:7.872px;background-color:rgb(229,229,229)"> </span><span class="gmail-syntax_punct" style="color:fuchsia;font-family:sans-serif;font-size:7.872px;background-color:rgb(229,229,229)">*</span><span style="color:rgb(0,0,0);font-family:sans-serif;font-size:7.872px;background-color:rgb(229,229,229)"> </span><span class="gmail-syntax_alpha gmail-syntax_alpha_reservedWord" style="color:rgb(153,0,153);text-transform:uppercase;font-weight:bold;font-family:sans-serif;font-size:7.872px;background-color:rgb(229,229,229)">FROM</span><span style="color:rgb(0,0,0);font-family:sans-serif;font-size:7.872px;background-color:rgb(229,229,229)"> </span><span class="gmail-syntax_alpha gmail-syntax_alpha_identifier" style="color:rgb(0,0,0);font-family:sans-serif;font-size:7.872px;background-color:rgb(229,229,229)">SJH </span><span class="gmail-syntax_alpha gmail-syntax_alpha_reservedWord" style="color:rgb(153,0,153);text-transform:uppercase;font-weight:bold;font-family:sans-serif;font-size:7.872px;background-color:rgb(229,229,229)">JOIN</span><span style="color:rgb(0,0,0);font-family:sans-serif;font-size:7.872px;background-color:rgb(229,229,229)"> </span><span class="gmail-syntax_alpha gmail-syntax_alpha_identifier" style="color:rgb(0,0,0);font-family:sans-serif;font-size:7.872px;background-color:rgb(229,229,229)">sjhliaison</span><span style="color:rgb(0,0,0);font-family:sans-serif;font-size:7.872px;background-color:rgb(229,229,229)"> </span><span class="gmail-syntax_alpha gmail-syntax_alpha_reservedWord" style="color:rgb(153,0,153);text-transform:uppercase;font-weight:bold;font-family:sans-serif;font-size:7.872px;background-color:rgb(229,229,229)">ON</span><span style="color:rgb(0,0,0);font-family:sans-serif;font-size:7.872px;background-color:rgb(229,229,229)"> </span><span class="gmail-syntax_punct gmail-syntax_punct_bracket_open_round" style="color:fuchsia;font-family:sans-serif;font-size:7.872px;background-color:rgb(229,229,229)">(</span><span style="color:rgb(0,0,0);font-family:sans-serif;font-size:7.872px;background-color:rgb(229,229,229)"> </span><span class="gmail-syntax_alpha gmail-syntax_alpha_identifier" style="color:rgb(0,0,0);font-family:sans-serif;font-size:7.872px;background-color:rgb(229,229,229)">SJH</span><span class="gmail-syntax_punct gmail-syntax_punct_qualifier" style="color:fuchsia;font-family:sans-serif;font-size:7.872px;background-color:rgb(229,229,229)">.</span><span class="gmail-syntax_alpha gmail-syntax_alpha_identifier" style="color:rgb(0,0,0);font-family:sans-serif;font-size:7.872px;background-color:rgb(229,229,229)">ID</span><span style="color:rgb(0,0,0);font-family:sans-serif;font-size:7.872px;background-color:rgb(229,229,229)"> </span><span class="gmail-syntax_punct" style="color:fuchsia;font-family:sans-serif;font-size:7.872px;background-color:rgb(229,229,229)">=</span><span style="color:rgb(0,0,0);font-family:sans-serif;font-size:7.872px;background-color:rgb(229,229,229)"> </span><span class="gmail-syntax_alpha gmail-syntax_alpha_identifier" style="color:rgb(0,0,0);font-family:sans-serif;font-size:7.872px;background-color:rgb(229,229,229)">sjhliaison</span><span class="gmail-syntax_punct gmail-syntax_punct_qualifier" style="color:fuchsia;font-family:sans-serif;font-size:7.872px;background-color:rgb(229,229,229)">.</span><span class="gmail-syntax_alpha gmail-syntax_alpha_identifier" style="color:rgb(0,0,0);font-family:sans-serif;font-size:7.872px;background-color:rgb(229,229,229)">PID </span><span class="gmail-syntax_alpha gmail-syntax_alpha_reservedWord" style="color:rgb(153,0,153);text-transform:uppercase;font-weight:bold;font-family:sans-serif;font-size:7.872px;background-color:rgb(229,229,229)">AND</span><span style="color:rgb(0,0,0);font-family:sans-serif;font-size:7.872px;background-color:rgb(229,229,229)"> </span><span class="gmail-syntax_alpha gmail-syntax_alpha_identifier" style="color:rgb(0,0,0);font-family:sans-serif;font-size:7.872px;background-color:rgb(229,229,229)">sjhliaison</span><span class="gmail-syntax_punct gmail-syntax_punct_qualifier" style="color:fuchsia;font-family:sans-serif;font-size:7.872px;background-color:rgb(229,229,229)">.</span><span class="gmail-syntax_alpha gmail-syntax_alpha_identifier" style="color:rgb(0,0,0);font-family:sans-serif;font-size:7.872px;background-color:rgb(229,229,229)">Tlid</span><span style="color:rgb(0,0,0);font-family:sans-serif;font-size:7.872px;background-color:rgb(229,229,229)"> </span><span class="gmail-syntax_punct" style="color:fuchsia;font-family:sans-serif;font-size:7.872px;background-color:rgb(229,229,229)">=</span><span style="color:rgb(0,0,0);font-family:sans-serif;font-size:7.872px;background-color:rgb(229,229,229)"> </span><span class="gmail-syntax_quote gmail-syntax_quote_single" style="color:rgb(0,128,0);white-space:pre;font-family:sans-serif;font-size:7.872px;background-color:rgb(229,229,229)">'28'</span><span style="color:rgb(0,0,0);font-family:sans-serif;font-size:7.872px;background-color:rgb(229,229,229)"> </span><span class="gmail-syntax_punct gmail-syntax_punct_bracket_close_round" style="color:fuchsia;font-family:sans-serif;font-size:7.872px;background-color:rgb(229,229,229)">)</span><span style="color:rgb(0,0,0);font-family:sans-serif;font-size:7.872px;background-color:rgb(229,229,229)"> </span><span class="gmail-syntax_alpha gmail-syntax_alpha_reservedWord" style="color:rgb(153,0,153);text-transform:uppercase;font-weight:bold;font-family:sans-serif;font-size:7.872px;background-color:rgb(229,229,229)">WHERE</span><span style="color:rgb(0,0,0);font-family:sans-serif;font-size:7.872px;background-color:rgb(229,229,229)"> </span><span class="gmail-syntax_alpha gmail-syntax_alpha_identifier" style="color:rgb(0,0,0);font-family:sans-serif;font-size:7.872px;background-color:rgb(229,229,229)">sjhFrancais</span><span style="color:rgb(0,0,0);font-family:sans-serif;font-size:7.872px;background-color:rgb(229,229,229)"> </span><span class="gmail-syntax_alpha gmail-syntax_alpha_reservedWord" style="color:rgb(153,0,153);text-transform:uppercase;font-weight:bold;font-family:sans-serif;font-size:7.872px;background-color:rgb(229,229,229)">LIKE</span><span style="color:rgb(0,0,0);font-family:sans-serif;font-size:7.872px;background-color:rgb(229,229,229)"> </span><span class="gmail-syntax_quote gmail-syntax_quote_single" style="color:rgb(0,128,0);white-space:pre;font-family:sans-serif;font-size:7.872px;background-color:rgb(229,229,229)">'osier%';</span><font face="times new roman, serif" size="4"><br></font></div><div class="gmail_signature"><div dir="ltr"><div><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div><div dir="ltr"><div><span><div style="font-size:large;display:inline"><br></div></span></div><div><span><div style="display:inline"><div class="gmail_default" style="font-size:large;font-family:"times new roman",serif">I have 3 answers :</div><div class="gmail_default" style="font-size:large;font-family:"times new roman",serif"><span style="background-color:rgb(255,255,221);color:rgb(0,0,0);font-family:sans-serif;font-size:9.84px">Affichage des enregistrements 0 - 2 (3 total, Traitement en 0.0147 sec.)</span></div><div class="gmail_default" style="font-size:large;font-family:"times new roman",serif"><span style="background-color:rgb(255,255,221);color:rgb(0,0,0);font-family:sans-serif;font-size:9.84px"><br></span></div><div class="gmail_default" style="font-family:"times new roman",serif"><span style="background-color:rgb(255,255,221);color:rgb(0,0,0);font-family:sans-serif"><font size="4">But when i try this with php</font></span><span style="background-color:rgb(255,255,221);color:rgb(0,0,0);font-family:sans-serif"><font size="1"> : </font><b style=""><font size="4">Aucun mot ne correspond !</font></b></span></div><div class="gmail_default" style="font-size:large;font-family:"times new roman",serif"><span style="background-color:rgb(255,255,221);color:rgb(0,0,0);font-family:sans-serif;font-size:9.84px"><img src="cid:ii_jhs8oped0_163adf767cf41a39" style="margin-right: 0px;"><br><br></span></div><div class="gmail_default" style="font-size:large;font-family:"times new roman",serif"><span style="background-color:rgb(255,255,221);color:rgb(0,0,0);font-family:sans-serif;font-size:9.84px"><br></span></div><div class="gmail_default" style="font-size:large;font-family:"times new roman",serif"><span style="background-color:rgb(255,255,221);color:rgb(0,0,0);font-family:sans-serif;font-size:9.84px"><br></span></div></div></span><span><div style="font-size:large;display:inline"><br><br></div></span></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div>
</div>