<?php
$pubname=$_POST["pname"];
$servername = "localhost";
$username = "root";
$password = "jit123";
$dbname = "1jt14cs019db4";

$conn = new mysqli($servername, $username, $password, $dbname);

if ($conn->connect_error)
{
        die("connection failed: " . $conn->connect_error);
}
else
{

        $sqlQuery = "update catalog set price=price+price*0.1 where publisher_id in(select publisher_id from publisher where pname='$pubname')";

        $result = $conn->query($sqlQuery);

        }






echo $pubname;

$conn->close();
?>