How to check if db entry exists then update or insert?

97 Posts

9 years ago

Topic

Hi I'm struggling trying to do this.

I've got a bookmark app which works fine but I need to stop duplicate entries if the user clicks the bookmark button more than once.

I think using before render plugin to check if entry exists for the current user then update or insert is the way to go.

In the table #__cck_store_item_user_notes I have columns id - bookmark_parent_id - bookmark_title

Any help coding this will be greatly appreciated.

Thanks

Anjo