Re: php and tables
| From: | graeme | Date: | Mon, 18 Apr 2005 02:58:50 +0000 |
| Subject: | Re: php and tables | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-39216@lists.php.net to get a copy of this message | ||
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-- Experience is a good teacher, but she sends in terrific bills. Minna AntrimTEAM PLAYED WIN LOSS DRAW POINTS AVERAGE ENGLAND 16 6 6 4 16 1.00I 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