You have to have the SQL update query in a PHP file and execute that PHP script via AJAX. For example:

In PHP:

$page_id = mysql_real_escape_string(html_entities($_POST['page_id']));

$rating = mysql_real_escape_string(html_entities($_POST['rating']));



mysql_query( UPDATE ratings(vote) VALUES ('$rating') WHERE id = '$page_id' );

AJAX (assuming you are using jQuery):

function rate(rating, page_id)

{



   $.ajax({

      url: 'path/to/php_script.php',

      type: 'post',

      data: 'rating='+rating+'&page_id='+page_id,

      success: function(output) 

      {

          alert('success, server says '+output);

      }, error: function()

      {

          alert('something went wrong, rating failed');

      }

   });



}

HTML:

<form>   

   Like: <input type=button value=Like onClick=rate(1, $_GET['page_id']) />

   <br />

   Hate: <input type=button value=Hate onClick=rate(2, $_GET['page_id']) />

</form>