// connect to mySQL
if (!($conn_id = @mysql_connect ("216.247.255.139","user1130376","q2h7miff5r")))
die ("Cannot connect to server\n");
// connect to database
if (!@mysql_select_db ("lungcancerallianceorg", $conn_id))
die ("Cannot select database\n");
// Performing SQL query
$result = mysql_query("SELECT * FROM petitioncounter") or die('Query failed: ' . mysql_error());
while ($listing = mysql_fetch_array($result, MYSQL_ASSOC)) {
echo "Join the ".(2264+$listing['signatures']+$listing['pdfdownloads'])."\n";
}
echo " people who have already signed or "."downloaded the petition to make lung cancer "."a national public health priority and increase federal research funding.";
// Free resultset
mysql_free_result($result);
// disconnect from mySQL
mysql_close ($conn_id);
?>
Learn more >>

LCA Releases the 4th Annual National Report Card on Lung Cancer. LCA-CA, LCA-GA, and LCA-MA Issue State Report Cards on Lung Cancer.
Learn more >>
LCA on YouTube! See the inspirational stories of lung cancer survivors. Upload your own! Learn more >>
LCA-NE advocate John Atkinson won the Golf Digest U.S. Open Challenge! Learn more about John. Watch the first video from his upcoming documentary!
Learn More >>
LCA joins Stand Up To Cancer as member of Advocate Advisory Council. Telethon raising money for cancer research to air on September 5, 2008.
Learn More >>
New LCA Store open for business! Purchase shirts, hats, sweatshirts with the LCA logo and spread awareness!
Learn More >>
LCA on YouTube! See the inspirational stories of lung cancer survivors. Upload your own! Learn more >>
Award winning author, motivational speaker and lung cancer survivor, Gayle Zinda, partners with LCA
Learn more >>
Dana Reeve's sister honors her one year memorial by taking the message to Washington.
Learn more >>
LCA Mourns Passing of Diane Rothschild, LCA Board Member and creator of LCA's "No More" Ad CampaignLearn more >>
Upcoming LCA Events
Items go here.
Learn more >>
Need Text Here.Learn more >>