PDA

View Full Version : سوال: اصلاح ticker news



rash44
چهارشنبه 29 خرداد 1392, 15:14 عصر
سلام

لطفا بخش مربوط به دریافت دادهها از دیتابیس این کد رو اصلاح کنید .



<?php
//
require_once('db.php');
$link = db_connect();
//
$sqlst="SELECT `id`,`name` FROM `category` order by `id` desc LIMIT 5";
$resultst=mysql_query($sqlst);
//
//$row=mysql_fetch_assoc($resultst);
//$news1=$row['name'];
?>
<!DOCTYPE html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>www.darkcms.ir</title>
</head>
<body>
<center>
<a id="tickerAnchor" style="font:12px Tahoma; color:red; text-decoration:none;" dir="rtl"></a>
</center>
<script language="JavaScript" type="text/javascript">
<!--
// Ticker startup
function startTicker()
{
// Define run time values
theCurrentStory = -1;
theCurrentLength = 0;
// Locate base objects
if (document.getElementById) {
theAnchorObject = document.getElementById("tickerAnchor");
runTheTicker();
}
else {
document.write("<style>.ticki{display:none;}.ticko{border:0px; padding:0px;}</style>");
return true;
}
}
// Ticker main run loop
function runTheTicker()
{
var myTimeout;
// Go for the next story data block
if(theCurrentLength == 0)
{
theCurrentStory++;
theCurrentStory = theCurrentStory % theItemCount;
theStorySummary = theSummaries[theCurrentStory].replace(/"/g,'"');
theTargetLink = theSiteLinks[theCurrentStory];
theAnchorObject.href = theTargetLink;
thePrefix = "<span class=\"tickls\">" + theLeadString + "</span>";
}
// Stuff the current ticker text into the anchor
theAnchorObject.innerHTML = thePrefix +
theStorySummary.substring(0,theCurrentLength) + whatWidget();
// Modify the length for the substring and define the timer
if(theCurrentLength != theStorySummary.length)
{
theCurrentLength++;
myTimeout = theCharacterTimeout;
}
else
{
theCurrentLength = 0;
myTimeout = theStoryTimeout;
}
// Call up the next cycle of the ticker
setTimeout("runTheTicker()", myTimeout);

}
// Widget generator
function whatWidget()
{
if(theCurrentLength == theStorySummary.length)
{
return theWidgetNone;
}

if((theCurrentLength % 2) == 1)
{
return theWidgetOne;
}
else
{
return theWidgetTwo;
}
}
// -->
</script>


<script language="JavaScript" type="text/javascript">
<!--

var theCharacterTimeout = 50;
var theStoryTimeout = 5000;
var theWidgetOne = "_";
var theWidgetTwo = "-";
var theWidgetNone = "";
var theLeadString = "";

var theSummaries = new Array();
var theSiteLinks = new Array();

var theItemCount = 6;
<?php while($row=mysql_fetch_assoc($resultst)) {
echo "theSummaries[$row[id]] = $row[name]";
} ?>
startTicker();
</script>
</body>
</html>