hi, i have finally got my database set up for club timetrial results.
I have got the first round results being pulled out of the database like this
array(6) {
["round_num"]=>
string(1) "1"
["round_date"]=>
string(10) "2015-04-15"
["rider_firstname"]=>
string(4) "firstname"
["rider_lastname"]=>
string(10) "lastname"
["club_name"]=>
string(14) "clubname"
["rider_time"]=>
string( "00:22:03"
}
array(6) {
["round_num"]=>
string(1) "1"
["round_date"]=>
string(10) "2015-04-15"
["rider_firstname"]=>
string(4) "firstname"
["rider_lastname"]=>
string(7) "lastname"
["club_name"]=>
string(9) "clubname"
["rider_time"]=>
string( "00:22:11"
}
array(6) {
["round_num"]=>
string(1) "1"
["round_date"]=>
string(10) "2015-04-15"
["rider_firstname"]=>
string(5) "firstname"
["rider_lastname"]=>
string(7) "lastname"
["club_name"]=>
string(14) "clubname"
["rider_time"]=>
string( "00:22:21"
}
from a while($result = mysqli_fetch_assoc($query)) (if that is the best way of doing it)
Is there anyway of looping through them and assigning a position i.e. 1, 2 ,3, 4 etc and account for people who finish with the same time so will have to be the same number but then skip a few to get back on track?
Hope it makes sense
Thanks