Code: Select all
$result = mysql_query("SELECT * FROM relate WHERE keyword LIKE '%$row->title%'");
while ($row = mysql_fetch_object($result))
{
echo "$row->keyword";
} mysql_free_result($result);We run a backend DB Table where we put all manner of keywords relating to products on another web site.
ie, car, van, ford.
Consumer goes to a product page, and finds a Ford Truck.
At the bottom of this page, it should say "find keywords in Relate, where they are like the Product Title on this page.
So since the title is "Ford Truck", it should have found the "ford" entry.
The query above isn't doing that.