Looking for suggestions on how to best pull some data. I need to do some calcs but pull the data by year and month to make a table like such.
2012 2013 2014 Jan $243 $567 $890 Feb $123 $456 $908 Mar Apr May I can get the data to be ordered by year, month but as you know that is not easily conducive to putting it into an HTML table without some middle ware storing and iterating through found sets. Suggestions? Thanks, Steffan --------------------------------------------------------------- T E L 6 0 2 . 7 9 3 . 0 0 1 4 | F A X 6 0 2 . 9 7 1 . 1 6 9 4 Steffan A. Cline stef...@execuchoice.net http://www.ExecuChoice.net Phoenix, Arizona USA --------------------------------------------------------------- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql