Re: [PHP-DB] php and tables

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 som
e basic code. I needed to print the information out on a table with the high
est 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