Problems with my site

[Barbiegirl]

hi.. um im making a game.. and basicly... the problem im having is i cant get the code to read frmo the database, who you are, what wing your in, and then show the infrastrucutre of that wing..


sorry ill explain what i mean..

the game is made of up real players... each player can either create a wing... or they can join a wing.... if you create a wing. it imputs the wing ID.. "auto increment" ito the database.. and it imputs the name you select... it also imputs the ID of the commander... "the commander is the person who CREATED the wing"

when a wing is created... under the "wings" table.. it makes the wing ID, commander, name, and then the list of members... like this...

Commander
Vice commander
Finance officer
Defence Officer
Tactics Officer
Member1
Member2
Member3
Member4
Member5
Beginner1
Beginner2
Beginner3
Noob1
Noob2
Noob3



so each person who wnats to join a wing.. has to apply to one of those positions and if the commander accepts.. then there ID is imputed into one of the fields...



A wing is made up of sectros "areas" it has 9 sectors.. with 300 buildings in each sector... when you start the game.. it will automaticy give you 150 buildings.... this all goes under the wings table too... it kinda looks like this

Command Center1 - INT
Command Center2 - INT
Command Center3 - INT
Command Center4 - INT
Command Center5 - INT
Command Center6 - INT
Command Center7 - INT
Command Center8 - INT
Command Center9 - INT


this stands for each sector the Command center is in... and then i just put int to show.. that you would IMPUT how many of those you have...


so now what im trying to do...

is lets say your the Member4... in the wing called... "testwing"

so you click the infrastructure page... and now the PHP i want to read who you are.... accorind to your ID #... and then what wing your in.......... and then i want to display the data i put on the page... but for that wing..


can anyone pleeeeeeeeeease help me im stuck... iv asked my dad and he doesnt know and i dont know what else i can do pls pls help

 

[Peter]

Before we can really help you we need to know the structure of the tables. It is most likely a join you are looking to do.

 

[Barbiegirl]

n.m

thanks anyways.. got it myself lol