https://www.webmaster-forums.net/crss/node/1022441 en https://www.webmaster-forums.net/serverside-scripting/need-some-help#comment-1138508 <p>Setup your db relations to allow it....<br /> <div class="codeblock"><code>Player<br />+-----------+----------+<br />| player_id | name&nbsp;&nbsp;&nbsp;&nbsp; |<br />+-----------+----------+<br />|&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1 |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Joe |<br />|&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2 |&nbsp;&nbsp;&nbsp;&nbsp; Jane |<br />|&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3 |&nbsp;&nbsp;&nbsp;&nbsp; John |<br />+-----------+----------+<br /><br />Fleet<br />+----------+-----------+------------+<br />| fleet_id | player_fk | name&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |<br />+----------+-----------+------------+<br />|&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1 |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1 | Red Fleet&nbsp; |<br />|&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2 |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1 | Blue Fleet |<br />|&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3 |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2 | Fleet One&nbsp; |<br />|&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 4 |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3 | Alpha One&nbsp; |<br />+----------+-----------+------------+</code></div>'</p> Mon, 29 Sep 2003 07:44:56 +0000 Mark Hensler comment 1138508 at https://www.webmaster-forums.net