View Full Version : delete problem

02-24-2007, 02:33 AM
hi, i ahve some query problem....below is my code.

include 'connStr.php';
include 'datediff.php';

$query = "SELECT * FROM tblpatient";
$result = mysql_query($query);
$row = mysql_fetch_assoc($result);
while ($row = mysql_fetch_array($result)){

$query2 = "Select * from tbloverdue";
$result2 = mysql_query($query2);
$row2 = mysql_fetch_assoc($result2);

$TD = $row["Treatment_Date"];
$patientID = $row["Patient_ID"];
$overdueID = $row2["Patient_ID"];

$diff = datediff("$TD","now","m");

if (($row["Email"]) == ""){
$row["Email"] = "NO";}

if ($diff > 5 && $patientID != $overdueID){

$query1 = "Insert into tbloverdue(Patient_ID, Name, Treatment_Date, Email)values('".$row["Patient_ID"]."', '".$row["Name"]."', '".$row["Treatment_Date"]."', '".$row["Email"]."')";
$result1 = mysql_query($query1);


$query3 = "DELETE o.* FROM tbloverdue as o, (SELECT MAX(Overdue_ID) AS dupid, COUNT(Patient_ID) AS dupcnt FROM tbloverdue GROUP BY Patient_ID, HAVING dupcnt>1) AS dups WHERE o.Patient_ID = dups.dupcnt";
$result3 = mysql_query($query3);


echo "<meta http-equiv=\"Content-Type\" content=\"text/html; charset=iso-8859-1\">";
echo "<meta http-equiv=\"REFRESH\" content=\"0; URL=overdue.php\">";


the INSERT query works properly...but the DELETE query cannot work at all...actually the DELETE query is to delete the duplicate records.but dunno y it cant works at all...
can somebody help me pls???????

02-24-2007, 10:43 AM
are you writing this yourself?

where are you getting this code