How datas retrieved from SQlite are stored as 'list of favorites' in android?

I am developing an Android application where you should be able to browse certain recipes.

I am retrieving the information about the recipes from SQLite database table, and retrieved some columns in a listview form. Now I want to store some of the retrieved datas into my favourites page, when I click favourite button in list. How can it possible..I want to implement "Add to favourites" feature in my app

How can I store that kind of info in the form of listview Using SQlite database?

Any ideas? Example code?

Solution

Just add a new table to your SQLite database called favourites, and store the recipe_id in there.