$db = mysql_connect("brilliantlemming.com", "bancap", "bcpass"); mysql_select_db("bancap",$db); $list = mysql_query("SELECT news_id, publication_nm, newsdate_dm, headline_tx FROM news ORDER BY newsdate_dm DESC"); ?>
Press Coverage
Date
Publication
Headline
$counter = 0; while ($mylist = mysql_fetch_array($list)) { $counter = $counter + 1; $id = $mylist["news_id"]; $rowcolor = floor($counter * .5); $rowcolor2 = $rowcolor*2; $rowcolor3 = $counter-$rowcolor2; if ($rowcolor3 > 0) { echo "
"; } else { echo "
"; } echo "
"; echo "
"; echo " " .$mylist["newsdate_dm"]; echo "
"; echo "
"; echo $mylist["publication_nm"]; echo "
"; echo "
"; echo $mylist["headline_tx"]; echo "
"; } ?>