Error with code.. Please check it out
<p>I have two tables and I want to show a list items of particular table as hyperlink only if its value exist in another table. Otherwise it show value as plain text not hyperlink.</p>

<p>Considering example...</p>

<pre><code>$result= mysql_query("select * from tbl_songlist_info order by song_title") or die(mysql_error());
$resultpoet= mysql_query("select * from tbl_poet_info") or die(mysql_error());
$rowpoet= mysql_fetch_array($resultpoet);
while($row = mysql_fetch_array($result)) 
</code></pre>

<p>Now I have to show values of <code>$row</code> as hyperlink only if its value exist in <code>$rowpoet</code>.. I have used in array function. please chk it out...</p>

<pre><code>&lt;? if (in_array($row['poet_name'],$rowpoet)) { ?&gt;
&lt;a href="poet.php?title=&lt;?=$row['poet_name'] ?&gt;"&gt;&lt;? } ?&gt;
&lt;?=$row['poet_name'] ?&gt; &lt;/a&gt;
</code></pre>

<p>please check this code. All value are showing as plain text if value exist in other table than also...</p>
