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
TEAMPLAYED 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