I want to include a dynamicaly created anchor that links to a search page that displays all users from that company. Users are allowed to be affiliated with more than one company. The information is being pulled from a mysql database example:
John Doe is affiliated with:
- Pepsi Company
- Cold Drinks Inc Company
- Sports Drinks Company
John Doe is affiliated with:
<a href="search/useraffiliation1"> Pespi Company</a>
<a href="search/useraffiliation2"> Cold Drinks Inc Company</a>
<a href="search/useraffiliation3"> Sports Drinks Company</a>
1.Whats the best way to go about doing this.
2.Whats the best way to structure my database. Should I use a single column for each affiliation or put all the affiliations in one.