-
help on script
Hello good pple of the forum i need to modify a particular script on DD which is pause up -down scrolling script. What i want to do is to integrate it with my access database. displaying the records as the database is inserted or updated. The problem i am having is displaying all the database in the scroller at once. What i am doing now is displaying the records using an array,however the way i am doing this limits the number of records to be displayed. Also, sometimes the content in the database comes in single and double how can escape both at once. Cheers
PHP Code:
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Untitled Document</title>
<%
Dim conn,rs,sql_select,data_source
set conn=server.CreateObject("ADODB.CONNECTION")
set rs=server.CreateObject("adodb.recordset")
data_source="Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & _
Server.MapPath("db\test.mdb")
conn.open data_source
sql_select="SELECT * FROM coursequestion_getconnected"
rs.open sql_select,conn,3,1
dim v(1)
dim i
do until rs.eof
v(i)=rs("coursequest")
i=i+1
rs.movenext:loop
%>
<script>
var pausecontent2=new Array()
pausecontent2[0]="<%=v(0)%>"
pausecontent2[1]="<%=v(1)%>"
</script>
</head>
<body>
<script type="text/javascript">
//new pausescroller(name_of_message_array, CSS_ID, CSS_classname, pause_in_miliseconds)
new pausescroller(pausecontent2, "pscroller1", "someclass", 2000)
</script>
</body>
</html>
