Untitled

<!doctype html>
<html>
<head>
<meta charset="utf-8">
  <title>LIKE AND UNLIKE</title>
<script src="http://code.jquery.com/jquery-1.3.2.min.js"></script>
<script>
        function doAction(postid,type){
            $.post("doAjax.php", {postid:postid, type:type}, function(data){
                   $("#"+postid+"_"+type+"s").text(data);
                   });
        }

</script>

</head>

<body>

<?php

    include("db.php");//database connection

    $postid = 1; //default post

    $data =  mysql_fetch_object(mysql_query("SELECT 'like', 'unlike' FROM posts WHERE id='".$postid."'"));

?>


<a href="javascript:;" onClick="doAction('<?php echo $postid;?>,'like');">Like (<span id="<?php echo $postid; ?>_likes"><?php echo $data->like?></span>)    </a>

<a href="javascript:;" onClick="doAction('<?php echo $postid;?>,'unlike');">UnLIke (<span id="<?php echo $postid; ?>_unlikes"><?php echo $data->unlike?></span>)    </a>

</body>
</html>

$host = "localhost";
$user = "root";
$pass = "";
$db = "like";

$conn = mysql_connect($host, $user,$pass);
mysql_select_db($db,$conn) or die(mysql_error());

?>

include('db.php');

 if(!empty($_POST["postid"]) && $_POST["type"] != ""){

    if($_POST["type"] =="like"){
        mysql_query(" UPDATE posts SET 'like' = 'like' +1 WHERE id='".(int)$_POST['postid']."'");
        $num = mysql_fetch_row(mysql_query(" SELECT 'like' FROM posts WHERE id='".(int)$_POST['postid']."' LIMIT 1"));
    }elseif($_POST['type'] == 'unlike'){
        mysql_query(" UPDATE posts SET 'unlike' = 'unlike' +1 WHERE id='".(int)$_POST['postid']."'");
        $num = mysql_fetch_row(mysql_query(" SELECT 'unlike' FROM posts WHERE id='".(int)$_POST['postid']."' LIMIT 1"));
    }
    echo $num[0];

}

?>