Re: php and tables

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux