Alexander on Web Development

Here's the SQL that I based off a Views I was trying to use: SELECT url_alias.dst AS link, node_data_field_newsticker_reference.field_newsticker_text_value AS ticker_text FROM node node LEFT JOIN content_type_newsticker node_data_field_newsticker_reference ON node.vid = node_data_field_newsticker_reference.vid LEFT JOIN content_type_newsticker node_data_field_newsticker_weight ON node.vid = node_data_field_newsticker_weight.vid LEFT JOIN url_alias url_alias ON url_alias.src= CONCAT('node', '/', node_data_field_newsticker_reference.field_newsticker_reference_nid) WHERE (node.status <> 0) AND (node.type in ('newsticker')) ORDER BY node_data_field_newsticker_weight.field_newsticker_weight_value ASC; --Here's a reference to some of the resources I ended up using:-- Needed to make the MARQUEE element scroll more smoothly: -http://remysharp.com/2008/09/10/the-silky-smooth-marquee/ -http://remysharp.com/demo/marquee.html Needed to hide it while the page was loading and show it after the page was finished loading: -http://www.freshblurbs.com/correct-way-adding-javascript-onload-event-drupal -http://api.drupal.org/api/drupal/developer--topics--javascript_startup_guide.html/6 -http://api.drupal.org/api/drupal/developer--topics--javascript_startup_guide.html/6#drupal-js (This is what I finally used)