Featured links display before acceptance

[bobby9101]

i am using
Content visible to registered users only.on my index.php
and
Content visible to registered users only. on my main.tpl
this works nicely and displays the latest submitted featured link
HOWEVER it displays it before i have even accepted it
how can i make it so that it will display the older featured link until i accept the new one? :?:

[euwebdirectory]

Maybe you have to write somethink like ...

$feat1 = $db->GetAll("SELECT * FROM {$tables['link']['name']} WHERE FEATURED = 1 AND STATUS= 2 ORDER BY ID DESC LIMIT 0,1");
$tpl->assign('feat1', $feat1);


Yes?