One thing to remember when developing locally on a windows machine and then uploading to lunarpages linux servers is CASE SENSITIVITY.
I was doing some php and msql stuff locally and then uploaded to LP, took me a while to realise I hadn't been consistent with the casing of my table columns adn thats why it wouldnt work

UGH! Yes. This is what I should have read a week ago. >_<
And make sure your versions of PHP and MySQL are consistent, or that your code works with both. When exporting MySQL databases for your remote server, use MySQL 4 compatibility.