I cant delete my data

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • amrhi
    New Member
    • Sep 2006
    • 22

    I cant delete my data

    Please help me,
    I try to get global variables but failed. I cant delete my data
    my code

    [PHP][<a href=\"delete.p hp?del=$row[date]\">Delete</a>][/PHP]

    in delete.php
    i wrote

    [PHP]<?php
    include"../connect.php";
    $del=$_POST["del"];
    $sql_del=mysql_ query("delete from tbldataflt where date='$del'",$k oneksi)or die(mysql_error ());
    include"input_d ep.php";
    ?>[/PHP]
  • mainul
    New Member
    • Sep 2006
    • 51

    #2
    Try this.

    [PHP]
    <?
    echo "<a href=\"delete.p hp?del=".$row["date"]."\">Delete</a>";
    ?>
    [/PHP]

    and next time send the whole code and let us help you more perfectly.

    best regards,
    Mainul

    Comment

    • amrhi
      New Member
      • Sep 2006
      • 22

      #3
      my code

      [PHP]$cek_dup=mysql_ query("select count(*) as total from tbldataflt where date='$date' and fltdep='$fltdep '",$conecti) or die( mysql_error());
      $sql_dup=mysql_ fetch_array($ce k_dup);
      if($sql_dup["total"]>"1"){
      $no=1;
      $print_dup=mysq l_query("select * from tbldataflt where date='$date' and fltdep='$fltdep '",$connect) or die( mysql_error());
      while($printdat a_dup=mysql_fet ch_array($print _dup)){
      echo"<tr><td width=\"30%\">< font size=\"2\">$no</font></td>
      <td width=\"100%\"> <font size=\"2\">$pri ntdata_dup[tgl]</font></td>
      <td width=\"100%\"> <font size=\"2\">$pri ntdata_dup[fltdep]</font></td>
      <td width=\"100%\"> <font size=\"2\">[<a href=\"delete.p hp?del=$printda ta_dup[date]\">Delete</a>]</font></td>
      </tr>";
      $no++; [/PHP]

      i cant get the variable for del in delete.php

      [PHP]<?php
      include"../koneksi.php";
      $del=$HTTP_POST _VARS["del"];
      $sql_del=mysql_ query("delete from tbldataflt where date='$del'",$c onnect)or die(mysql_error ());
      include"input_d ep.php";
      ?>[/PHP]

      anyone can help me

      Comment

      Working...