Hello,
For displaying alternative colors I used the following codes.
<html>
<body>
<?php
$db = mysql_connect("localhost", "root");
mysql_select_db("mydb",$db);
$colourcounter = 0;
$query = mysql_query("select Ticker,Last,Vol from dailyclosing order by T_Change desc limit 10 ",$db);
$result = mysql_query($query) or die("ERROR");
//$query2 = "SELECT Ticker,Last,Vol from dailyclosing order by T_Change desc limit 5 $startrecord, $display";
// $result2 = mysql_query($query2) or die("ERROR");
// echo "<table border=1>\n";
print("<table border=0 align=center width=300 bgcolor=#0E711D cellpadding=\"2\" cellspacing=\"1\"><tr><td><font color=#FFFFFF><b>Fieldname1</b></font></td><td align=right><font color=#FFFFFF><b>Fieldname2</b></font></td></tr>");
// while ($myrow = mysql_fetch_row($result)) {
//printf("<tr><td>%s %s</td><td>%s</td></tr>\n", $myrow["Ticker"], $myrow["Last"], $myrow["Vol"]);
while(list(Ticker, Last) = mysql_fetch_row($result)) {
if ($colorcounter == 0) {
$colorbg = "#ECE28B";
}
else {
$colorbg = "#F4EFC1";
$colorcounter = $colorcounter - 2;
}
print("<tr><td bgcolor=$colorbg>$Field1</td><td align=right bgcolor=$colorbg>$Field2</td></tr>");
$colorcounter = $colorcounter + 1;
}
print("</table>");
?>
I am getting errors like
Parse error: parse error, unexpected T_STRING, expecting ',' or ')' in c:\program files\apache group\apache\htdocs\atlas\results.php on line 35
How can modify my above code to display alternative colors in my rows.
Thanks,
jc
