Ok i have a small snag. I have to read several rows of data from the DB by the current month and year. And these results are organized by a 'row_order' which is a separate field for all rows.
something like this:
$query = "SELECT * FROM table WHERE month='$this_month' AND year='$this_year' ORDER BY row_order ASC";
If i were to echo the results it would show me all the rows matching that month and year in ASCending order...
NOW Here is my question:
How do I? Only disply the row with the highest 'row_order' ?
So lets say the result looks like this:
Data | Aug | 2002 | 1
Data | Aug | 2002 | 2
Data | Aug | 2002 | 3
Data | Aug | 2002 | 4
how do I only display the row with the greates number? :
Data | Aug | 2002 | 4
