Duplicate Entries - Gallery Image Generation Help

[NanoEntity]

Gallery for http://nekio.com - in development...

Please look at the .jpg I have attached for the effect it generates.

I'm really having problems with this, if someone could help me with it, it would be great.

Thanks

v_entry
entryid title dateline
29 Test 1022235617

v_favorite
favoriteid entryid userid dateline
1 29 1 1052235616
2 29 2 1052235616
3 29 3 1052235616


$entries = $DB_site->query("SELECT
v_entry.*,
v_favorite.entryid AS favoriteentryid,
v_favorite.userid AS favoriteuserid,
v_favorite.dateline AS favoritedateline
FROM v_entry
LEFT JOIN v_favorite ON (v_favorite.entryid=v_entry.entryid)
WHERE v_favorite.userid='1'
ORDER BY v_favorite.dateline DESC
LIMIT $perpage");

while ($entry = $DB_site->fetch_array($entries)) {
if ($entry['favoriteuserid']==$bbuserinfo['userid']) {
$entrybits .= "Unsubscribe<br>";
}
eval("\$entrybits .= \"".gettemplate("v_$thumb")."\";");
}

[Xenon]

Have you tried SELECT DISTINCT ?

[NanoEntity]

yes still same effect...

[NanoEntity]

i fixed it, :) thanks for the help