Show values in different colours

[JasonDFR]

Before you get guys get carried away, perhaps it is better to look at the database queries being used, then figure out a way to only return the results you want. It would be better to build a query that only returns the data you want, rather than trying to manipulate your result to get rid of bad data.

Rob, perhaps you could post the query you are using. There is this one in your code: $query="select * from strokeaverage ORDER BY `rank` ASC "; Is that it? If so, how is the rank being determined? Are all the scores placed into this table? Also post a description of the table being used to store the data. Is the list of scores on your website basically a representation of the table in the db? If so that means that each time a new match is played somebody is adding a new column and then filling in each person's score? How is the rank calculated?

[Rob (SA)]

Hi,

Thank you for the interest and understanding of my requirement.

We have previously used an excel spreadsheet to present our averages and rankings. This does not work to well hence the plan to move foward.

The scores are scores from golf games and currently it represnets what is in my table in MySql.

The actula idea is to have this table linked to a page that captures scores to the database.

These scores will then be manipulated by scripts to produce various results.

That is:

The Domestic Averages
The National Averages
The Rankings of all the players
The top 10 players from each age group u18,u16,u14,u12 and girls

The rankings as you see it are the current rankings but are not ranking determined by any script.

I have been busy with the look and feel side and hopefully not chasing myself in the wrong direction.

I look forward to your replies.

Regards
Rob

[Rob (SA)]

Hi Jason,

I would appreciate any assitance I can get to get tis part of my strokaverages working.

I am at a place which is pretty simple in design at the moment if it helps for you to see what my ideas are:

http://www.gnjgf.co.za/strokeaverage.php

Our current stroke averages ar efound at http://www.gnjgf.co.za/GNJGF_OOM_BOYS.htm

If either of you are keen to develop the entire project you are more than welocme to contact me and we can plan ahead.

Thanks again for all your help

Regards
Rob