Jquery into Drupal 7 I'm trying to get this: http://jsfiddle.net/SgHJ5/
to work in Drupal 7. 

For some reason, when I paste it into my front--page.tpl (footer) it doesnt work.

I've also tried including a JS file into my template.php.
jQuery in D7 is in noConflict mode. You need to use jQuery instead of $, or a closure.
See http://drupal.org/node/171213