So I have a query which pulls all the right data but I am having problems going through the data and pulling out the right data.
I have this Query:
SELECT meets.meet_id, meets_athletes.total_score, events.event, meets_athletes_splits.split_number, meets_athletes_splits.split_score
FROM meets INNER JOIN meets_athletes ON meets.meet_id = meets_athletes.meet_id
LEFT JOIN meets_athletes_splits ON meets_athletes.meet_id = meets_athletes_splits.meet_id AND meets_athletes.athlete_id = meets_athletes_splits.athlete_id AND meets_athletes.event_id = meets_athletes_splits.event_id
INNER JOIN events ON meets_athletes.event_id = events.event_id
WHERE meets_athletes.athlete_id = 1
Image: http://ift.tt/1JmSbMS
I would like the data returned like so:
Meet 1 String:
Event: 5000 Meter Long Distance
Total Score 1:35.4
Split 1: 0:00.0
Split 2: 0:12.4
Split 3: 0:16.5
Split 4: 0:49.4
Event: 800 Meter Middle Distance
Total Score: 0:48.3
Split 1:
Meet 2 String:
Event: 5000 Meter Long Distance
Total Score:
Split 1:
Event: 800 Meter Middle Distance
Total Score:
Split 1:
I am trying to return a string per meet with the events and splits included per event. I don't know how to really do this in Android. Any help would be much appreciated
Aucun commentaire:
Enregistrer un commentaire