Duplicate entries in db

programming
1

Ok, so I have a page which pulls db entries and they display fine. When the array is echoed it spits out a form with one input field, one textarea and a save and delete button for each entry. Each input field and textarea are initiated with a value of the corresponding values in the db, but when I try to delete or save just one entry, it applies the changes to all entries in the db. I understand why this is happening, but I don’t know how to fix it. Also, when the user hits save or delete, the results are not echoed again. It still displays the pre-edit results although the updates were made in the db. Here is my code:


<?php 
$db_host = "localhost";
$db_user = "user";
$db_pwd = "pwd";
$db_name = "db";
$connect = mysql_connect($db_host, $db_user, $db_pwd) or die("Could not connect to mySQL");
$selected = mysql_select_db($db_name, $connect) or die("Could not select database john");
$call = mysql_query("SELECT * FROM tname");
$status = "<p>Below are the units that are presently listed on your site.  Use the corresponding buttons below to edit or remove these listings. If you would like to change the picture for a listing, please delete the entire listing and upload a new one.</p>";

if(isset($_POST['save'])){ 
    $query1 = "UPDATE tname SET title = '$image'";
    $query2 = "UPDATE tname SET description = '$description'";
    $result1 = mysql_query($query1) or die ('Error: '.mysql_error ());
    $result2 = mysql_query($query2) or die ('Error: '.mysql_error ());
    $status = "<p>Success, your changes have been saved.</p>";
    }
    
/*if(isset($_POST['delete'])){
    //$query="DELETE FROM tname WHERE title = $title";
    $query="DELETE FROM tname WHERE description = '$description'";
    $result = mysql_query($query) or die ('Error: '.mysql_error ());
    $status = "Success, your deletions have been made.";
    }*/
?><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Rent-A-Shed :: Portable Storage Containers</title>
<link href="styles.css" rel="stylesheet" type="text/css" />
<script src="../Scripts/AC_RunActiveContent.js" type="text/javascript"></script>
</head>

<body>
<div id="container"><img src="../images/logo.png" alt="Rent-A-Shed" width="190" height="45" border="0" class="logo" />
<div id="edit">
<h1>Edit or Remove</h1><?php echo $status; ?><br />
<?php
while($row = mysql_fetch_array($call)){
$image = $row["img"];
$image_title = $row["title"];
$image_description = $row["description"];
?><div id="purchasecontainer"><img src="<?php echo $image; ?>" align="left" width="150" height="150"/></div><div id="purchasecontent"><form action="<?php echo $PHP_SELF; ?>" method="post"><p>Title:</p><input name="image" type="text" class="inputs" id="title" value="<?php echo $image_title; ?>" /><p>Description:</p><textarea name="description" id="description"><?php echo $image_description; ?></textarea><input name="save" type="submit" class="save" value="Save" /><input name="delete" type="submit" class="delete" value="Delete" /></form></div>
<?php 
}
?></div>
<div id="footer"><p>&copy; 2007 BJ Equipment, Inc All Rights Reserved</p></div>
</div>
</body>
</html>