¡@
php Programming Glossary: scoredMixing different categories results, ordered by score in MySQL http://stackoverflow.com/questions/6244787/mixing-different-categories-results-ordered-by-score-in-mysql is how can I perform a query that returns the highest scored articles while alternating them by categories so that if possible.. are returned consecutively. For example if the highest scored article has score 100 the returning set would be something like..
how to output a standings table on the fly from a mysql table of football [soccer] results? http://stackoverflow.com/questions/8009379/how-to-output-a-standings-table-on-the-fly-from-a-mysql-table-of-football-socce 5 0 3 2 8 12 4 3 POS Position W won D Draw L Loss F Goals scored For A Goals scored against GD Goals difference Pts Points I.. Position W won D Draw L Loss F Goals scored For A Goals scored against GD Goals difference Pts Points I think the most efficient.. would be to assign wins draws and losses sum the goals scored and goals scored against and when echoing out the data calculate..
|