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

PHP Code:

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 


PHP Code:

        $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