Need Some Help

They have: 40 posts

Joined: Aug 2002

I dont really know what to call the title Smiling

well, long time no see Smiling
I havent been in here in a LONG while Sticking out tongue

But, heres the problem Im having...

-------------

Im coding a PHP based game. Multiple Planets, Massive multiplayer Space Strategy game.

I need to be able to have unlimited amounts of fleets for each player.

Im Using MYSQL, and I dont really have one single clue on how to do that....

Thz for the help
- Corey/Mankiy

Gamerz Central
Mankiy Productions - All Mankiys Art on ONE Site

Mark Hensler's picture

He has: 4,048 posts

Joined: Aug 2000

Setup your db relations to allow it....

Player
+-----------+----------+
| player_id | name     |
+-----------+----------+
|         1 |      Joe |
|         2 |     Jane |
|         3 |     John |
+-----------+----------+

Fleet
+----------+-----------+------------+
| fleet_id | player_fk | name       |
+----------+-----------+------------+
|        1 |         1 | Red Fleet  |
|        2 |         1 | Blue Fleet |
|        3 |         2 | Fleet One  |
|        4 |         3 | Alpha One  |
+----------+-----------+------------+
'

Mark Hensler
If there is no answer on Google, then there is no question.

Want to join the discussion? Create an account or log in if you already have one. Joining is fast, free and painless! We’ll even whisk you back here when you’ve finished.