Sort Repeat Region

brattt

I have a table with 3 columns. Points, Matches, and Average.

'Points' and 'Matches' are getting their values from a mysql database and for the 'Average' I'm dividing 'Score' by 'Matches' using the following php code:

<?php echo bcdiv($row_rstbl_players1['Points'], $row_rstbl_players1['Matches'], 2);
?>

These results are all being displayed using Dreamweaver's 'Repeat Region' function.

My question is: Is there a way to have a heading above the Average column, that is actually a link, which when clicked on, will sort the results in ascending/descending order?

Or, is there a way to get the database to automatically divide the 'Points' column value by the 'Matches' column value and fill the 'Average' column with the result?

Any guidance with regards to either of the above two questions would be very helpful.

khendar

Not sure about the DW thing - but for the database query have you tried

UPDATE table set average = points/matches

This will thrown an unknown error of matches happens to be zero.

brattt

Thanks. That works great but I'll need the table to update whenever the scores change.

khendar

So your update query will be:

UPDATE table set points = $points, matches=$matches, average= points/matches;

brattt

Thanks for that. I was using MX Collection Nextensio to build the queries so I'll have to do away with that and re-write it myself. Finally if I have the results ordered by Score descending, is there a way to assign them a 'Rank'. I've tried using an auto-number bit of script, but the numbers don't actually have any values so when I search the records the 'Rank' doesn't work. Hope that makes sense.