kanala Posted August 23, 2007 Share Posted August 23, 2007 What's wrong with this? $similar = $row['Similar'];$keywords = $row['Keywords'];$result2 = mysql_query("SELECT * FROM Products WHERE lower(Keywords) LIKE lower('%$similar%) OR lower(Similar) like lower('%$keywords%') LIMIT 8");while($row2 = mysql_fetch_array($result2)) It only works if I don't use OR $similar = $row['Similar'];$keywords = $row['Keywords'];$result2 = mysql_query("SELECT * FROM Products WHERE lower(Keywords) LIKE lower('%$similar%) LIMIT 8");while($row2 = mysql_fetch_array($result2)) Link to comment Share on other sites More sharing options...
Kristian_C Posted August 23, 2007 Share Posted August 23, 2007 $similar = $row['Similar'];$keywords = $row['Keywords'];$result2 = mysql_query("SELECT * FROM Products WHERE lower(Keywords) LIKE lower('%$similar%') OR lower(Similar) like lower('%$keywords%') LIMIT 8");while($row2 = mysql_fetch_array($result2));try that... Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.