Unable to connect to the in blogs inc/index " . "database server at this time.

" ); exit(); } // Select the database if (! @mysql_select_db("$DBname") ) { echo( "

Unable to locate the DataBase at this time blogs inc/index 2.

" ); exit(); } if (empty($Category) OR ($Category == "All Categories")) { $sql = "SELECT * FROM blogs ORDER BY `Blog_artnr` DESC "; $Blog_Category = "All Categories"; } else { $sql = "SELECT * FROM blogs WHERE Blog_Category = '$Category' ORDER BY `Blog_artnr` ASC "; } $result = MYSQL_QUERY($sql); //we add this line because we need to know the number of rows $numberOfRows = MYSQL_NUM_ROWS($result); //Check to see if any reviews exist in the cateory if ($numberOfRows == "0") { echo"

$Blog_name's in the $Category Category Coming Soon!

"; } //else reviews exist in category else { // //Now lets get the category description // $sql2 = "SELECT * FROM blog_menu WHERE Title = '$Category' "; $result2 = MYSQL_QUERY($sql2); $numberOfRows2 = MYSQL_NUM_ROWS($result2); if ($numberOfRows2==0) { // } else if ($numberOfRows2>0) { $i2=0; while ($i2<$numberOfRows2) { $thisArtnr = MYSQL_RESULT($result2,$i2,"Blog_Menu_artnr"); $thisTitle = MYSQL_RESULT($result2,$i2,"Title"); $thisMeta_Description = MYSQL_RESULT($result2,$i2,"Meta_Description"); $thisMeta_Keywords = MYSQL_RESULT($result2,$i2,"Meta_Keywords"); $thisProgram_Promote = MYSQL_RESULT($result2,$i2,"Program_Promote"); $thisShow_RSS = MYSQL_RESULT($result2,$i2,"Show_RSS"); $thisMeta_Description = stripslashes("$thisMeta_Description"); $i2++; } // end while loop } // end of if numberOfRows > 0 if (empty($Category) OR ($Category == "All Categories")) { $thisMeta_Description = "a list of all postings from all Categories here at Have Web Sites Will Travel"; $thisTitle = "List of All Blogs"; } // //End getting the category description // ?>

:
This Category contains

" border="0" cellspacing="4" cellpadding="2" align="center"> ', "", "$Blog_Summary"); $Blog_Summary = str_replace('

', "", "$Blog_Summary"); $Blog_Summary = stripslashes("$Blog_Summary"); $Meta_Description = MYSQL_RESULT($result,$i,"Meta_Description"); $Meta_Description = stripslashes("$Meta_Description"); $Meta_Keywords = MYSQL_RESULT($result,$i,"Meta_Keywords"); $Blog_Content = MYSQL_RESULT($result,$i,"Blog_Content"); $Blog_Content = stripslashes("$Blog_Content"); $Year_Blog_Written = MYSQL_RESULT($result,$i,"Year_Blog_Written"); $Month_Blog_Written = MYSQL_RESULT($result,$i,"Month_Blog_Written"); $Day_Blog_Written = MYSQL_RESULT($result,$i,"Day_Blog_Written"); $Day_of_Week_Blog_Written = MYSQL_RESULT($result,$i,"Day_of_Week_Blog_Written"); $Hour_Blog_Written = MYSQL_RESULT($result,$i,"Hour_Blog_Written"); $Rating = MYSQL_RESULT($result,$i,"Rating"); $Viewed = MYSQL_RESULT($result,$i,"viewed"); $Viewed = number_format($Viewed); $Show_RSS = MYSQL_RESULT($result,$i,"Show_RSS"); $Blog_file_name = MYSQL_RESULT($result,$i,"Blog_file"); if ($Month_Blog_Written == "1") { $month = "Jan"; $month_long = "January"; } if ($Month_Blog_Written == "2") { $month = "Feb"; $month_long = "February"; } if ($Month_Blog_Written == "3") { $month = "Mar"; $month_long = "March"; } if ($Month_Blog_Written == "4") { $month = "Apr"; $month_long = "April"; } if ($Month_Blog_Written == "5") { $month = "May"; $month_long = "May"; } if ($Month_Blog_Written == "6") { $month = "Jun"; $month_long = "June"; } if ($Month_Blog_Written == "7") { $month = "Jul"; $month_long = "July"; } if ($Month_Blog_Written == "8") { $month = "Aug"; $month_long = "August"; } if ($Month_Blog_Written == "9") { $month = "Sep"; $month_long = "September"; } if ($Month_Blog_Written == "10") { $month = "Oct"; $month_long = "October"; } if ($Month_Blog_Written == "11") { $month = "Nov"; $month_long = "November"; } if ($Month_Blog_Written == "12") { $month = "Dec"; $month_long = "December"; } echo "\n"; echo ""; echo "\n"; } echo "
$Blog_Title $Day_Blog_Written $month_long $Year_Blog_Written
\n"; //End else reviews exist in category } $Bottom = "Yes"; include("$DOCUMENT_ROOT/$Blog_Location/inc/Blog_Menu.inc.php"); ?>