<?php

$sql_host = "localhost";
$sql_user = "root";
$sql_pass = "root";
$db_name = "items";

$data_sql = mysql_connect($sql_host, $sql_user, $sql_pass);
if (!$data_sql) die("Can't connect to MySql");
mysql_select_db($db_name,$data_sql) or die("Can't select database");

$pricz = mysql_query("SELECT * FROM items WHERE username='admin'");
$unsold = mysql_fetch_assoc($pricz);

echo ' <p>The current price is: <strong  style="color:orange">';

    if($unsold['unsold'] != ''){
        echo $unsold['unsold'];
    }else {
        echo '<b>You havent added a price yet.';
    }

echo '
    <center><form action="" method="post" >
    <input type="text" name="price" placeholder="Enter new Price"/>
    <input class="button" type="submit" name="submitprc" value="Save"></form>';

if(isset($_POST['submitprc'])){
    $price = $_POST['price'];
	mysql_query("update items set unsold=(unsold + '$price') where username='admin'");
}

/*

--
-- Table structure for table `items`
--

CREATE TABLE `items` (
  `id` int(6) NOT NULL,
  `username` varchar(30) NOT NULL,
  `unsold` decimal(10,2) NOT NULL,
  `sold` decimal(10,2) NOT NULL,
) ENGINE=MyISAM DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `items`
--

INSERT INTO `items` (`id`, `username`, `unsold`, `sold`) VALUES
(1, 'admin', '0.00', '0.50');
*/

?>