1st Get your SQL to ORDER BY points DESC
2nd use PHP to get the details on row at a time and display the results in an HTML table.


The specifics will depend on what your table looks like, for example if you don't have a points column then you may need to get SQL to calculate it.

graeme.

Vikas Nanda wrote:

Hi

I am new to php and mysql and am having a few problems that I hope someone can 
help with.

What I am trying to do is to display ratings for particular teams using some 
basic code. I needed to print the information out on a table with the highest 
average at the top and then ascending. I have all this info stored in a mysql 
db.
eg
TEAM        PLAYED  WIN   LOSS   DRAW  POINTS   AVERAGE
ENGLAND     16           6         6          4          16              1.00

I don't know how to print variables out in a table and I don't know how to make 
it ascending.

Any help would be much appreciated.

Thanks

Vikas

Send instant messages to your online friends http://uk.messenger.yahoo.com


-- Experience is a good teacher, but she sends in terrific bills.

Minna Antrim

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



Reply via email to