news ticker
Posted: Thu Apr 09, 2009 11:31 pm
Hi,
I have designed a news ticker so that through php it gathers data from the database through an odbc connect from one field. Now here what I have done so far:
The problem is nothing shows up in my ticker..how do I go about displaying the message field through my tickertape?
Thanks
I have designed a news ticker so that through php it gathers data from the database through an odbc connect from one field. Now here what I have done so far:
Code: Select all
?>
<TABLE style="BORDER-RIGHT: #000000 0px double; PADDING-RIGHT: 0px; BORDER-TOP: #000000 0px double; PADDING-LEFT: 0px; FONT-WEIGHT: bold; FONT-SIZE: 10px; BACKGROUND-IMAGE: PADDING-BOTTOM: 0px; MARGIN: 0px; VERTICAL-ALIGN: top; BORDER-LEFT: #000000 0px double; WIDTH: 140px; COLOR: #ffffff; PADDING-TOP: 0px; BORDER-BOTTOM: #000000 0px double; FONT-STYLE: normal; FONT-FAMILY: Arial, Helvetica, sans-serif; TEXT-DECORATION: none" cellSpacing=0 cellPadding=0 bgcolor=#00000 >
<TBODY>
<TR>
<TD style="BORDER-RIGHT: #0910a3 1px double; PADDING-RIGHT: 4px; BORDER-TOP: #0910a3 1px double; PADDING-LEFT: 4px; FONT-WEIGHT: bold; FONT-SIZE: 10px; MARGIN: 0px; VERTICAL-ALIGN: top; BORDER-LEFT: #0910a3 1px double; COLOR: #ffffff; LINE-HEIGHT: normal; PADDING-TOP: 4px; BORDER-BOTTOM: #0910a3 1px double; BACKGROUND-REPEAT: repeat-x; FONT-STYLE: normal; FONT-FAMILY: Arial, Helvetica, sans-serif; HEIGHT: 22px; TEXT-DECORATION: none; FONT-SIZE: 11px; COLOR: #ffffff; FONT-FAMILY: Verdana, Helvetica, Arial "><B><FONT color=#ffffff> News
Ticker</FONT></B></TD></TR>
<TR>
<TD style="BORDER-RIGHT: #0910a3 1px double; PADDING-RIGHT: 4px; BACKGROUND-POSITION: center bottom; BORDER-TOP: #0910a3 1px double; PADDING-LEFT: 4px; FONT-WEIGHT: bold; FONT-SIZE: 10px; PADDING-BOTTOM: 15px; MARGIN: 0px; VERTICAL-ALIGN: top; BORDER-LEFT: #0910a3 1px double; COLOR: #ffffff; LINE-HEIGHT: normal; PADDING-TOP: 4px; BORDER-BOTTOM: #0910a3 1px double; BACKGROUND-REPEAT: repeat-x; FONT-STYLE: normal; FONT-FAMILY: Arial, Helvetica, sans-serif; TEXT-DECORATION: none FONT-SIZE: 11px; COLOR: #ffffff; FONT-FAMILY: Verdana, Helvetica, Arial">
<MARQUEE onmouseover=this.stop() onmouseout=this.start()
scrollAmount=1 direction=up width="100%" height=100><?php
$sql="SELECT message FROM Table1";
$rs=@odbc_exec($conn,$sql);
while (odbc_fetch_row($rs))
{
echo $message."<BR>";}
odbc_close($conn);
?></MARQUEE></TD></TR></TBODY></TABLE>
Thanks