$conn = Connect_nhsinlgesDB();
$sql="SELECT * from homepage WHERE keyword = '$keyword' ";//echo"$sql";
$getRecordsSQL = @mysql_query($sql) or $error .= "
Your Query: $sql has an error."; //echo"$sql";
$HaveRows = mysql_num_rows($getRecordsSQL);
//echo $HaveRows;
if($HaveRows >=1 ) {
while ($rows = mysql_fetch_object($getRecordsSQL)) {
//$keyword = str_replace(' ', "_", $rows->keyword);
//echo$rows->body_text;
$bodyText = ereg_replace ( "##TEXT##", $rows->keyword, $rows->body_text);
echo$bodyText;
}
} else {
?>
Site Map
Please visit New Hampshire (NH) links
$sqlCats="SELECT DISTINCT catagory from homepage";
$getCatRecordsSQL = @mysql_query($sqlCats) or $error .= "Your Query: $sql has an error."; //echo"$sql";
while ($catRow = mysql_fetch_object($getCatRecordsSQL)) {
$catagoyDisplay = str_replace('_', " ", $catRow->catagory);
//echo"$catRow->catagory $catagoyDisplay
";
echo"
$catagoyDisplay |
";
echo"";
$sql="SELECT * from homepage where catagory = '$catRow->catagory'";
$getRecordsSQL = @mysql_query($sql) or $error .= "Your Query: $sql has an error."; //echo"$sql";
$counter = 1;
while ($rows = mysql_fetch_object($getRecordsSQL)) {
$keyword = str_replace(' ', "_", $rows->keyword);
echo"\n\t| $rows->keyword | \n";
if ($counter == 2){
echo" ";
$counter = "0";
}
$counter ++;
}
echo"
|
";
}
?>
}?>