I'm actually wanting to execute this connection, SQL call, and results display:
<?php
// Create the connection file with connection information
$host = "hostname";
$username = "username";
$password = "password";
// Connect to Database
$connection = @mysql_connect($host,$username,$password);
mysql_select_db(database_name,$connection);
$result = mysql_query("SELECT DATE_FORMAT(date,'%b %d, %Y') as article_day, `article_name`, `article_link`, `article_text` FROM `table_name` WHERE `date` <= CURDATE() ORDER BY event_date LIMIT 3");
while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
echo '<div class="cssarticle">
<div class="headline">'. $row["article_name"] .'</div>
<div class="articledate">'. $row["article_day"].'</div>
<div class="articleintro">'. $row["article_text"].'</div>
<div class="articlelink"><a href="'. $row["article_link"].'">Read More...</a></div>
</div>';
}
mysql_free_result($result);
?>
I'm extremely, extremely new to Coldfusion, so if someone could help show me how to do this, it'd be better than the initial request of PHP in CF.
Thanks so much!!