just need a point in the right direction

natatkinson

I'm not a complete newb, but I have not worked much with arrays, which I think is what i need here.

So I am creating a page that gets data from a postgresql database, the page is here: http://www.eiublue.com/topten/indoor_men.php

This is for my track and field team. Times are entered into the database, the two main tables are results and result_athlete (my full ERD is here. This allows for relays (multiple athletes in a single event, the result_id is listed multiple times in the results table with separate athlete_ids).

Here are the rules for a top ten list
-No athlete can be on a list for an event more than
--No relay team (all 4 members in the same order) can be on a list more than once.

So I am thinking I might need to add a 'leg' column to my result_athlete to keep track of what leg of the relay each person runs.

But my real problem is on the output, and if the result is outputted or not (becuase of only being limited to 1 apperace per list).

Any help would be appreciated.

bpat1434

Seems like you didn't finish your post..... 🙁

natatkinson

Yeah, accidentally hit enter. My post is now complete (hopefully). Hopefully someone can throw me a bone.

bpat1434

Well, you might be able to select a DISTINCT ath_id so you don't get duplicates, but not sure if that will muck up your data though.

You could also manually on each array do an [man]array_search/man or [man]array_walk/man and comparatively look at the arrays. There's also [man]array_unique[/man], but that's for single-dimension arrays.

You might have to play around with each one and see what you can come up with.

natatkinson

awesome, I appreciate the response. I've actually never used arrays before, but now I have the chance. I'll play around with that.

I don't think distinct ath_id would work, because an athlete could be on the list multiple times if he ran on different relays (relay members in a different order).

I'll work on it, and let you know.