Jump to content

Help with a marquee scroll up Script


srhino

Recommended Posts

Can anyone point me in the right direction for a script that will allow me to have my php information scroll up continously...I have a database of golf scores that I would like to have scroll up from bottom to top automatically...I have one now but it stops scrolling after the first 25 entries. If there is something I can change in the script that would be great.

 

 

//Specify the marquee's width (in pixels)
var marqueewidth="1014px"
//Specify the marquee's height
var marqueeheight="550px"
//Specify the marquee's marquee speed (larger is faster 1-10)
var marqueespeed=1
//Pause marquee onMousever (0=no. 1=yes)?
var pauseit=0

//Specify the marquee's content
//Keep all content on ONE line, and backslash any single quotations (ie: that\'s great):

var marqueecontent=' <?php $tournid = $_GET['tourn']; $con = mysql_connect("XXXXXX", "XXXXX", "XXXXX") or die('Could not connect to database'); mysql_select_db("bestball", $con) or die('Sorry could not connect to the dadtabase'); $query = "SELECT *, rd1+rd2+rd3+rd4 AS ToPar FROM scoring WHERE tournid = $tournid order by rd1 + rd2 + rd3 + rd4"; $result = mysql_query($query) or die('Could not find Tournament: ' . mysql_error ()); $rank = 1; $recordCounter = 1; $previousScore = 0; $previousToPar=-99; while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) { $score_array = array();  $score_array[] = $row['ToPar']; $team = $row['team']; for($i=1;$i<=5;$i++){ $p[$i] = $row['p' . $i]; } $th = $row['th']; $p1 = $row['p1']; $p2 = $row['p2']; $p3 = $row['p3']; $p4 = $row['p4']; $p5 = $row['p5']; $score = $row['score']; $course = $row['course']; $rd1 = $row['rd1']; $rd2 = $row['rd2']; $rd3 = $row['rd3']; $rd4 = $row['rd4']; $ttl = $row['ToPar']; if ($previousToPar != $ttl){$rank = $recordCounter;} echo "<table align=\"center\" width=\"1014\" border=\"0\"><tr><td class=\"rank\" align=\"center\" rowspan=\"4\" width=\"200\">$rank</td><td class=\"player\" align=\"center\" width=\"414\">$p1</td><td class=\"score\" align=\"center\" rowspan=\"4\" width=\"200\">$rd1</td><td class=\"thru\" align=\"center\" rowspan=\"4\" width=\"200\">$th</td></tr><tr><td class=\"player\" align=\"center\" width=\"414\">$p2</td></tr><tr><td class=\"player\" align=\"center\" width=\"414\">$p3</td></tr><tr><td class=\"player\" align=\"center\" width=\"414\">$p4</td></tr></table> ";  $recordCounter++; $previousToPar = $ttl; } ?>'



////NO NEED TO EDIT BELOW THIS LINE////////////

marqueespeed=(document.all)? marqueespeed : Math.max(1, marqueespeed-1) //slow speed down by 1 for NS
var copyspeed=marqueespeed
var pausespeed=(pauseit==0)? copyspeed: 0
var iedom=document.all||document.getElementById
var actualheight=''
var cross_marquee, ns_marquee

function populate(){
if (iedom){
cross_marquee=document.getElementById? document.getElementById("iemarquee") : document.all.iemarquee
cross_marquee.style.top=parseInt(marqueeheight)+8+"px"
cross_marquee.innerHTML=marqueecontent
actualheight=cross_marquee.offsetHeight
}
else if (document.layers){
ns_marquee=document.ns_marquee.document.ns_marquee2
ns_marquee.top=parseInt(marqueeheight)+8
ns_marquee.document.write(marqueecontent)
ns_marquee.document.close()
actualheight=ns_marquee.document.height
}
lefttime=setInterval("scrollmarquee()",20)
}
window.onload=populate

function scrollmarquee(){

if (iedom){
if (parseInt(cross_marquee.style.top)>(actualheight*(-1)+)
cross_marquee.style.top=parseInt(cross_marquee.style.top)-copyspeed+"px"
else
cross_marquee.style.top=parseInt(marqueeheight)+8+"px"
}
else if (document.layers){
if (ns_marquee.top>(actualheight*(-1)+)
ns_marquee.top-=copyspeed
else
ns_marquee.top=parseInt(marqueeheight)+8
}
}

if (iedom||document.layers){
with (document){
if (iedom){
write('<div style="position:relative;width:'+marqueewidth+';height:'+marqueeheight+';overflow:hidden" onMouseover="copyspeed=pausespeed" onMouseout="copyspeed=marqueespeed">')
write('<div id="iemarquee" style="position:absolute;left:0px;top:0px;width:100%;">')
write('</div></div>')
}
else if (document.layers){
write('<ilayer width='+marqueewidth+' height='+marqueeheight+' name="ns_marquee">')
write('<layer name="ns_marquee2" width='+marqueewidth+' height='+marqueeheight+' left=0 top=0 onMouseover="copyspeed=pausespeed" onMouseout="copyspeed=marqueespeed"></layer>')
write('</ilayer>')

 

Thanks !

 

Link to comment
Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.