|
|
$artId = $_GET['article_id'];
mysql_connect($dbHost,$username,$password);
@mysql_select_db($database_re) or die( "Unable to select database");
$query = "SELECT id, title, content, category FROM resource_articles WHERE id =$artId";
$result = mysql_query($query);
$num = mysql_numrows($result);
mysql_close();
$i=0;
while ($i < $num) {
$artId = mysql_result($result, $i, "id");
$artTitle = mysql_result($result, $i, "title");
$artContent = mysql_result($result, $i, "content");
$artCategory = mysql_result($result, $i, "category");
?>
if ($artCategory == 'market_summary'){?>
Market Summary
}else if($artCategory == 'market_stats'){?>
Market Statistics
}else if($artCategory == 'buyers_n_sellers'){?>
Buyers & Sellers
}else if($artCategory == 'find_a_home'){?>
Find A Home
}else if($artCategory == 'relocation'){?>
Relocation
}else if($artCategory == 'Financing'){?>
Financing
}else if($artCategory == 'home_improvement'){?>
Home Inspection
}else if($artCategory == 'your_home_and_taxes'){?>
Your Home & Taxes
} if($artCategory == 'faq'){?>
FAQ
} ?>
echo"$artTitle ";?>
echo "$artContent"; ?>
|
$i++;
}
?>
back to news
|
|
advertisement
|
|
|
|
|
|
|
|