Creating a favorite list in PHP
<p>I'm developing a software portal, where users can add a software as favorite and when they do that, the software will get displayed in their profile.</p>

<p>For doing this, I planned to do the following:</p>

<p>There is a separate column named "favorites" in the "users" table. When a user adds a software as a favorite, then the software ID will get added using comma, like</p>

<pre><code>"102,405,502,695,595"
</code></pre>

<p>For displaying I planned to use PHP's explode function and query the software name after that.</p>

<p>My question is: what happens if the user has some 100 favorites? Does it take long time to load the list? Is there any other method to implement this concept?</p>
