Hi...
I've got an odd problem... I'm not exactly sure how to phrase it, so I wasn't able to find anything on a search.
What I have is a database where players record "missions" they play. Ideally, each mission the players play, they would get a 'bomb' icon on their aircraft page to indicate the number of missions they've played.
I'm having trouble figuring out how to get this to work.
The file itself (the 'bomb' picture) is "bomb.gif". The database is ordered so that each mission has a unique ID number (auto increment), and when a player submits a mission the user's user_id and their plane_id are added to the record for identification purposes.
So, for example, my database looks like this :
Mission
--------
mission_id user_id plane_id target result
1 3 5 Paris Bombed
2 2 6 Paris Bombed
3 3 5 Amiens Missed
4 8 40 Amiens Bombed
5 3 5 Stuttgart Bombed
Now, using the example above, I want to be able to have user #3 have three bombs show up on their user airplane page.
How do I do this? I've tried messing around with "mysql_num_rows" and such, but that didn't work. All I get is a single 'bomb.gif' picture.
Any help would be great... thanks a lot.
