i-CONICA
asked on
SQL Query to match similar items, but matches itself too? How to solve? :D
Hi,
I have an issue with a script's SQL query that I've written.
It looks for software items in the database similar to the current page.
The current page is identified by a string like:
avg-free-edition or zoom-player-premium or google-chrome
This string is called "shortname".
The script works well enough for now, the problem is, it's matching itself too.
The code i've got below is an example, it doesn't work, but this is where I've broken it trying to make it not match itself.
If anyone could correct this and make it work, that'd be awesome!
Thanks :D
I have an issue with a script's SQL query that I've written.
It looks for software items in the database similar to the current page.
The current page is identified by a string like:
avg-free-edition or zoom-player-premium or google-chrome
This string is called "shortname".
The script works well enough for now, the problem is, it's matching itself too.
The code i've got below is an example, it doesn't work, but this is where I've broken it trying to make it not match itself.
If anyone could correct this and make it work, that'd be awesome!
Thanks :D
$likevar = explode('-',$shortname);
$likevarquery = '';
foreach($likevar as $lick){
$likevarquery .= " or shortname LIKE '%$lick%'";
}
$likevarquery = substr($likevarquery,3); // strip off first 'or '
$likevarquery .= " AND shortname NOT LIKE '$shortname' ";
$query = "SELECT fullname, shortname, category, sicon FROM `soft_data` WHERE $likevarquery ORDER BY `date_updated` DESC LIMIT 0, 4";$result = mysql_query($query);
$num = mysql_num_rows($result);
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.