Filter results of database join element

[zegmis]

Hi,
i have "Add option in front end" enabled. After user adds new option, i want only to display that single record in dropdown list. Where now if user had 10 records added, all those records will be displayed in dropdown for selection as i am using database join filter

WHERE `shoe_userid` = {$my->id}

How could i return only recently added record?

Thanks!

 

[lcollong]

I would do :
WHERE `shoe_userid` = {$my->id} ORDER BY `id` DESC LIMIT x

"id" is the key (auto increment) of the lookup table and "x" should be the number of "last results" you want (1 ?)

 

[zegmis]

perfect - thanks a mill. works like a charm.