View Single Post
  #1  
Old 14th April 2011, 01:29
nicukent nicukent is offline
Senior Member
 
Join Date: Sep 2009
P2P
Posts: 40
Smile Scrolling top 10 Donors
Add this to index where you like:

PHP Code:
<?begin_frame("Top 10 Donors");?>
    <?
    $res 
mysql_query("SELECT * FROM users WHERE donor ='yes' ORDER BY donor DESC, username LIMIT 10") or sqlerr();

    echo 
'<table cellpadding=0 width="120%"><td colspan=5><td><tr><marquee bgcolor="transparent" direction="left" behavior="scroll" scroll="continuous" scrollamount="6" vspace="5" hspace="5" align="center" width="600" height="50" style="font-size:20px;color:#1589FF;font-family:verdana;">We would like to thank the following users for supporting '.$SITENAME.' ';

 
$i=20;

    while (
$row mysql_fetch_assoc($res))  {  $id $row['id'];
    
$name $row['username'];
    
$name str_replace('_'' ' $name);
    
$name str_replace('.'' ' $name);
    
$name substr($name050);

    if(
$i==0)echo'</marquee></tr></td><td><tr><marquee scrollAmount=2 onMouseover="this.scrollAmount=0" onMouseout="this.scrollAmount=2" scrolldelay="0" direction="right">';

echo 
"<a href=\"userdetails.php?id=$id\">$name <img src=pic/star.gif border=0></a> &nbsp;<strong></strong>&nbsp; ";
    
$i++;}
    echo 
"</marquee></td></tr></table>";

    
end_frame();?>

Change font color to what you need ,and the ammount of donors.


Please Do Not "PM" Me For Personal Support!


Reply With Quote
The Following 2 Users Say Thank You to nicukent For This Useful Post:
Baba (25th March 2020), wMan (13th May 2011)