Live Edit Table Issues

Your situation is not clear to me. Please be more descriptive. Paste more code here possibly the html form.

sorry... am not so good in explaning. Anyways, I have 3 .php file for this system. 1. index which is the first page displays the record and stuffs obviously. 2. is the table_edit that has the insert/update statement (use to update the table for No.ofRemainingProperties and insert No.ofRentedProperties), and 3rd was the saveinfo where the original insert statement from textboxes on the tab at the side of index was taken.

By default, the index must display the details from the db. On its side was a tab where the textboxes gathers the record for the ff: property_details,tenant,location,price,qty and the startDate. This will all go to the saveinfo.php. Once saved, the index would retrieve the everything from the db.
Well, not really everything since the No.ofRentedProperties must be empty. only the values of the ff columns would be displayed: Date, Stall Details, Tenant, No.ofRemaining Property and Rent Cost. The remaining property column has the original quantity. It will be reduced however when a value was added to RentedProperty.

Only when a value for No.ofRentedProperty was added through a live_edit_table format (similar to that of FB commentbox) should the the Amount Tendered would display the product of No.RentedProperty*Rent Cost.

here are the codes:

index.php

$sql=mysql_query("select * from inventory");
$i=1;
while($row=mysql_fetch_array($sql))
{
$id=$row['id'];
$item=$row['item'];
$tenant=$row['details'];
$location=$row['location'];
$qtyleft=$row['qtyleft'];
$qtysold=$row['qtysold'];
$price=$row['price'];
$sales=$row['sales'];
$date=$row['startDate'];

if($i%2)
{
?>
<tr id="<?php echo $id; ?>" class="edit_tr">
<?php } else { ?>
<tr id="<?php echo $id; ?>" bgcolor="#f2f2f2" class="edit_tr">
<?php } ?>
<input type="text" value="<?php echo $id; ?>" name="uid" hidden>
<td class="edit_td">
<span class="text"><?php echo $date; ?></span> 
</td>
<td>
<span class="text"><?php echo $item; ?></span> 
</td>
<td>
<span class="text"><?php echo $tenant; ?></span> 
</td>
<td>
<span class="text"><?php echo $location; ?></span> 
</td>
<td>
<span class="text"><?php echo $qtyleft; ?></span>
</td>
<td>

<span id="last_<?php echo $id; ?>" class="text">
<?php
$sqls=mysql_query("select * from sales where date='$date' and inventory_id='$id'");
while($rows=mysql_fetch_array($sqls))
{
echo $rows['qty'];
$rtrt=$rows['qty'];
}
?>
</span> 
<input type="text" value="<?php echo $qtyleft; ?>"  class="editbox" id="last_input_<?php echo $id; ?>" name="id"/>
</td>
<td>
<span id="first_<?php echo $id; ?>" class="text"><?php echo $price; ?></span>
<input type="text" value="<?php echo $price; ?>" class="editbox" id="first_input_<?php echo $id; ?>" />
</td>
<td>

<span class="text">
<?php
$sqls=mysql_query("select * from sales where date='$date' and inventory_id='$id'");
while($rows=mysql_fetch_array($sqls))
{
$rtyrty=$rows['qty'];
$rrrrr=$rtyrty*$price;
echo $rrrrr;
}

?>
</span> 
</td>
</tr>

<?php
$i++;
}
?>

</table>

<br />
Total Sales of this day:
        <b>Php <?php
function formatMoney($number, $fractional=false) {
    if ($fractional) {
        $number = sprintf('%.2f', $number);
    }
    while (true) {
        $replaced = preg_replace('/(-?\d+)(\d\d\d)/', '$1,$2', $number);
        if ($replaced != $number) {
            $number = $replaced;
        } else {
            break;
        }
    }
    return $number;
}       
$result1 = mysql_query("SELECT sum(sales) FROM sales where date='$date'");
while($row = mysql_fetch_array($result1))
{
    $rrr=$row['sum(sales)'];
    echo formatMoney($rrr, true);
 }

?>

table_edit.php

<?php
include("db.php");
if($_POST['id'])
{
$id=mysql_escape_String($_POST['id']);
$qty_sold=mysql_escape_String($_POST['qtysold']);
$price=mysql_escape_String($_POST['price']);
$da=$_POST['startDate'];
$qty=$_POST['qty'];
$sql=mysql_query("select * from inventory where id='$id'");
while($row=mysql_fetch_array($sql))
{
$qtyleft=$row['qtyleft'];
$price=$row['price'];
}
$ssss=$qtyleft-$qty_sold;
$sale=$qty_sold*$price;
$sales_sql=mysql_query("select * from sales where date='$da' and inventory_id='$id'");
$count=mysql_num_rows($sales_sql);

if($count==0)
{
mysql_query("INSERT INTO sales (inventory_id, qty, date, sales) VALUES ('$id','$qty_sold','$da','$sale')");
}
if($count!=0)
{
mysql_query("UPDATE sales set qty='$qty+$qty_sold',sales='$sale' where date='$da' and inventory_id='$id'");
}

$sql = "update inventory set qtyleft='$ssss',price='$price',sales=sales+'$sale',qty_sold=qty_sold+'$qty_sold' where id='$id'";
mysql_query($sql);
}
?>

saveinfo.php

<?php
include("db.php");
$proname=$_POST['proname'];
$tenant=$_POST['tenant'];
$location=$_POST['location'];
$price=$_POST['price'];
$pqty=$_POST['pqty'];
$qtysold=$_POST['qtysold'];
$date=$_POST['startDate'];
mysql_query("INSERT INTO inventory (item,details,location,qtyleft,qtysold,price,startDate) VALUES ('$proname','$tenant','$location','$pqty','$qtysold','$price','$date')");
?>