FHA Articles from Q & A Issues:");
$query = "select article.title,article.article_number,article.author,article.title_small,date_format(issue.issue_date,'%M %d, %Y') from article,issue where
article.article_type = 'FHA' and article.issue_number = issue.issue_number and issue.issue_title = 'MortgageCurrentcy.com Question and Answer' order by article.issue_number desc;";
$result = mysql_query($query);
echo("");
while ($myrow = mysql_fetch_row($result)){
if($myrow[3] != ""){
$the_title = $myrow[3];
}
else {
$the_title = $myrow[0];
}
if($myrow[4] != '' && $myrow[4] != 0){
$star_rating = "($myrow[4] ![](\"/images/star.gif\") 's)";
}
echo ("
- $star_rating $the_title- $myrow[4] ");
} // end while
echo("
");
?>
|