Updating my record
===

Dear friend i am trying to update the recode but the following message always come up

" You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 9"

the code looks fine but i do not understand what i am doing wrong can someone help.
thanks in Advance.

    <?php
    if(isset($_POST['edit'])){
             // this id wil be pulled from the URL above. 
            $hot_id     = $_GET['hotl'];  
            $hotel_name = escape_value($_POST['title']);
            $hotel_star = escape_value($_POST['category']);
            $shortdes   = escape_value($_POST['shortdes']);
            $country    = escape_value($_POST['country']);
            $address    = escape_value($_POST['address']);
            $pcode      = escape_value($_POST['pcod']);
            $city       = escape_value($_POST['city']);         
            
            $query = "UPDATE Hotels SET  
                      hotel_name = '{$hotel_name}',
                      star ='{$hotel_star}',
                      description = '{$shortdes}',
                      country = '{$country}',
                      hotel_address = '{$address}',
                      hotel_postal_code = '{$pcode}',
                      hotel_city = '{$city}'
                      WHERE hotel_id = {$hot_id}";                
                $result = mysql_query($query, $connection);
                
                if(mysql_affected_rows() == 1){
                //Success
                }else{
                die("Some thing wrong with the Upadate: ". mysql_error());
                }
                
            }else{
            //error ocurred
            }
    ?>
i am posting my question in both PHP and Mysql Forum because i do not know exaectly where is the problem.