ysql_real_escape_string() expects parameter 2 to be resource

include 'includes/connect.php';
$con = MysqlConnect::getInstance();

$adjacents = 3;
$count = $con->select("SELECT COUNT(*) as tot FROM `bsi_news_and_events` ", false);
$total_pages = $count['tot'];
$targetpage = "news_and_events.php";  //your file name  (the name of this file)
$limit = 5;         //how many items to show per page
$page = isset($_GET['page']) ? mysql_real_escape_string($_GET['page']) : 0;
if ($page)
    $start = ($page - 1) * $limit;    //first item to display on this page
else
    $start = 0;
//echo "SELECT * FROM `achiev` ORDER BY `achiev_id`  LIMIT ".$start." , ".$limit." ";
$result = $con->select("SELECT * FROM `bsi_news_and_events` ORDER BY `id` DESC  LIMIT " . $start . " , " . $limit . " ", true);
if ($page == 0)
    $page = 1;     //if no page var is given, default to 1.
$prev = $page - 1;       //previous page is page - 1
$next = $page + 1;       //next page is page + 1
$lastpage = ceil($total_pages / $limit);  //lastpage is = total pages / items per page, rounded up.
$lpm1 = $lastpage - 1;
$pagination = "";
if ($lastpage > 1) {
    $pagination .= "<div class=\"pagination\">";
    //previous button
    if ($page > 1)
        $pagination.= "<a href=\"$targetpage?page=$prev\" > &nbsp; < &nbsp;</a>";
    else
        $pagination.= "<span class=\"disabled\"> &nbsp; < &nbsp; </span>";

    //pages
    if ($lastpage < 7 + ($adjacents * 2)) { //not enough pages to bother breaking it up
        for ($counter = 1; $counter <= $lastpage; $counter++) {
            if ($counter == $page)
                $pagination.= "<span class=\"current\"> &nbsp; $counter</span>";
            else
                $pagination.= "<a href=\"$targetpage?page=$counter\"> &nbsp; $counter</a>";
        }
    }
    elseif ($lastpage > 5 + ($adjacents * 2)) { //enough pages to hide some
        //close to beginning; only hide later pages
        if ($page < 1 + ($adjacents * 2)) {
            for ($counter = 1; $counter < 4 + ($adjacents * 2); $counter++) {
                if ($counter == $page)
                    $pagination.= "<span class=\"current\"> &nbsp; $counter</span>";
                else
                    $pagination.= "<a href=\"$targetpage?page=$counter\"> &nbsp; $counter</a>";
            }
            $pagination.= "...";
            $pagination.= "<a href=\"$targetpage?page=$lpm1\">$lpm1</a>";
            $pagination.= "<a href=\"$targetpage?page=$lastpage\">$lastpage</a>";
        }
        //in middle; hide some front and some back
        elseif ($lastpage - ($adjacents * 2) > $page && $page > ($adjacents * 2)) {
            $pagination.= "<a href=\"$targetpage?page=1\">1</a>";
            $pagination.= "<a href=\"$targetpage?page=2\">2</a>";
            $pagination.= "...";
            for ($counter = $page - $adjacents; $counter <= $page + $adjacents; $counter++) {
                if ($counter == $page)
                    $pagination.= "<span class=\"current\"> &nbsp; $counter</span>";
                else
                    $pagination.= "<a href=\"$targetpage?page=$counter\"> &nbsp; $counter</a>";
            }
            $pagination.= "...";
            $pagination.= "<a href=\"$targetpage?page=$lpm1\">$lpm1</a>";
            $pagination.= "<a href=\"$targetpage?page=$lastpage\">$lastpage</a>";
        }
        //close to end; only hide early pages
        else {
            $pagination.= "<a href=\"$targetpage?page=1\">1</a>";
            $pagination.= "<a href=\"$targetpage?page=2\">2</a>";
            $pagination.= "...";
            for ($counter = $lastpage - (2 + ($adjacents * 2)); $counter <= $lastpage; $counter++) {
                if ($counter == $page)
                    $pagination.= "<span class=\"current\"> &nbsp; $counter</span>";
                else
                    $pagination.= "<a href=\"$targetpage?page=$counter\"> &nbsp; $counter</a>";
            }
        }
    }

    //next button
    if ($page < $counter - 1)
        $pagination.= "<a href=\"$targetpage?page=$next\">&nbsp; > </a>";
    else

        $pagination.= "<span class=\"disabled\">&nbsp; > </span>";
    $pagination.= "</div>\n";
}
?>