Simple php mysql pagination

<?php
$sql = "select COUNT(ID) from wp_posts where post_status='publish'    && post_type='post'";
$rs_result = mysql_query($sql);
$row = mysql_fetch_row($rs_result);
$total_records = $row[0];
$total_pages = ceil($total_records / 3);                   
                   
for ($i=1; $i<=$total_pages; $i++) {
    echo "<a href='index.php?page_id=99&page=".$i."'>".$i."</a> ";
};
?>
<?php

if (isset($_GET["page"])) { $page  = $_GET["page"]; } else { $page=1; };
$start_from = ($page-1) * 3;
$query=mysql_query("select * from wp_posts where post_status='publish'    && post_type='post' LIMIT $start_from, 3  ");       
        while($row=mysql_fetch_array($query))
        {   
                        ?>
<?php } ?>