Optional page text here. ConnectDB($cfg_hostserver, $cfg_username, $cfg_password); $db2use = $conn->SelectDB($cfg_database); //check for successful db connect/select if (!$dbConn || !$db2use) { //failure $title = "Database Connection Error"; $text = "The connection to the database could not be made at this time. Please try again later."; } else { //success //run query to get the listing $result_link = $conn->executeQuery("SELECT * FROM links ORDER BY LinkHierarchy LIMIT 0, 1"); //check for failure/success if (!$result_link) { //failure $title = "Data Retrieval Error"; $text = "The data that you requested could not be retrieved at this time; please try again later."; } else { //success //check for the no. of records $num_link = $conn->RecordCount($result_link); //check for the value of $num_link if ($num_link <= 0) { //the link id is invalid i.e. the associated information could not be found $title = "Page Not Found!"; $text = "The web page that you requested could not be found."; } else { //the link id is valid; grab the data $row_link = mysql_fetch_object($result_link); //populate the variables $title = $row_link->PageTitle; $text = $row_link->PageContent; $keywords = $row_link->Keywords; $description = $row_link->PageSummary; } //checking for the no. of records returned } //checking for query success/failure } //checking for successful db connection/selection ?>