delete function

[chinna]

hi guyz...i was stuck with my project for past few days because my delete function not working....now it working but not accurate....if i use...

	<?php
$sql = "select *from details";
$query = @mysql_query($sql);
$countData = @mysql_num_rows($query);
?>
    <td width="62" bgcolor="#CAF3F7"><div align="center" class="style12"><?php while ($nt=mysql_fetch_array($query))
{
echo "<a href='aftersave.php' name='delete' id='delete'>delete</a> <br> ";
}?>
<?php
if (isset($_REQUEST['delete']))
$select ="DELETE from details where amount = '$nt[amount]'";
$querys = @mysql_query($select);
$countDatas = @mysql_num_rows($querys);
?>

....it doest work..if i took out the isset($_REQUEST(delete))..its working...but delete the data directly even i didnt hit the delete button..

	<?php
$sql = "select *from details";
$query = @mysql_query($sql);
$countData = @mysql_num_rows($query);
?>
    <td width="62" bgcolor="#CAF3F7"><div align="center" class="style12"><?php while ($nt=mysql_fetch_array($query))
{
echo "<a href='aftersave.php' name='delete' id='delete'>delete</a> <br> ";
}?>
<?php
//if (isset($_REQUEST['delete']))
$select ="DELETE from details where amount = '$nt[amount]'";
$querys = @mysql_query($select);
$countDatas = @mysql_num_rows($querys);
?>

...please help...im realy have no idea...and my project getting very late...thanks in advanced

[leatherback]

Try like this:

<?php

$sql     = "select *, count(*) as count from details";
// Do not use the @ as it incorrectly supresses error you make in your code
$result = mysql_query($sql) or die(mysql_error());
if($result)
  {
  echo "<td width=\"62\" bgcolor=\"#CAF3F7\"><div align=\"center\" class=\"style12\">";

  while ($nt=mysql_fetch_array($result))
    {
    echo "<a href='aftersave.php' name='delete' id='delete'>delete</a> <br />";
    }
  }

if(isset($_GET['delete']) && $_GET['delete'] == 'delete')
  { // Note this bracket which is key!
  $sql              ="DELETE from details where amount = '$nt[amount]'";
  $result          = mysql_query($select) or die(mysql_error());
  $countDatas = mysql_num_rows($result);
  }
?> 

[leatherback]

Of course there are a lot of things in your code that do not make sense:

this link:
<a href='aftersave.php' name='delete' id='delete'>delete</a> <br />
does not tell you WHAT to delete, so on a page with multiple deletes it will not know what it is removing

This:
$sql ="DELETE from details where amount = '$nt[amount]'";
does not make sense. Who is to say that there is only one row with that amount?

If I didn't know better, I'd think this is what you are trying to do:

<?php
// FIRST update the database:

if(isset($_GET['delete'] && is_numeric($_GET['delete']))
  {
  // assuming there is an ID column to use
  $sql              ="DELETE from details where ID = $_GET['delete']";
  $result          = mysql_query($select) or die(mysql_error());
  }

// THEN create an overview
$sql     = "select * from details";
$result = mysql_query($sql) or die(mysql_error());
if($result)
  {
  while($row = mysql_fetch_array($result)
    {
    echo "
    <td width=\"62\" bgcolor=\"#CAF3F7\">
      <div align=\"center\" class=\"style12\">
         <a href='aftersave.php?delete=".$row['ID']."'>
           delete
         </a>
         <br />
      </div>
    </td>";
    }
  }
?>

[chinna]

here the solutions

<?
include "db1.php";
$t_id=$_REQUEST['t_id'];
$rec_id=$_REQUEST['rec_id'];
$link=$_REQUEST['link'];
$acc_no=$_REQUEST['acc_no'];
$item=$_REQUEST['item'];
$description=$_REQUEST['description'];
$amount==$_REQUEST['amount'];


if($link='delete')
{
$sql_delete="delete  from details where rec_id='$rec_id'";
$result_delete=mysql_query($sql_delete)or die(mysql_error());
header("location:aftersave.php?t_id=$t_id");
}
elseif($link='update')
{
$sql_update="update details set acc_no='$acc_no',
								item='$item',
								description='$description',
								amount='$amount'
								 where rec_id='$rec_id'";
$result_update=mysql_query($sql_update)or die(mysql_error());
header("location:aftersave.php?t_id=$t_id");
}


?>