public static function fetchFromDbForUrl($url)
{
$sql = "SELECT * FROM bsi_site_contents WHERE url = '" . mysql_escape_string($url) . "' ORDER BY ord";
$query = mysql_query($sql);
if (!$query) {
global $logger;
$logger->LogFatal("Error executing query: {$sql}");
$logger->LogFatal("Database error: " . mysql_errno() . ". Message: " . mysql_error());
die("Database error: " . mysql_errno() . ". Message: " . mysql_error());
}
if ($row = mysql_fetch_assoc($query)) {
$pageContents = PageContents::fetchFromParameters($row);
return $pageContents;
} else {
PageContents::setStaticError("No page contents with url " . $url . " could be found.");
return NULL;
}
}
