Unanswered: mySQL -> excel through PHP, THE SOLUTION
I have been trying to save my database as an excel file. After much research of looking at other codes and loads of trial and errors I was able to find what I needed- below is the code to do just that!
I have it saved as a stand-alone php file, with a link from another page that calls it. The page will pop=up an alert to save hte file, and viola!