news ticker

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
max_power
Forum Newbie
Posts: 5
Joined: Thu Apr 09, 2009 1:50 pm

news ticker

Post by max_power »

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:

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>&nbsp;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>
 
The problem is nothing shows up in my ticker..how do I go about displaying the message field through my tickertape?

Thanks
max_power
Forum Newbie
Posts: 5
Joined: Thu Apr 09, 2009 1:50 pm

Re: news ticker

Post by max_power »

Woops, found out that is actually working, but the font color is black so it isnt showing up because the background color is black itself, how can I change the font color with echo?

Thanks
Post Reply