Remove records

tsukey

Anyone can help me in this thing?

I have been trying for a long time but the same thing happens. I have a text file storing names of some softwares. These softwares need to store some records in the database.
Now, I want to remove the software's records in the database when I delete the affected software from the text file.

But the current coding I have works like this:

Only when I remove 2 softwares and more, everything works fine.
If I remove only 1 software, this record in the database would not be deleted till a second software is also deleted.

I have attached a file on the codes. First time coding...so a bit messy.

drawmack

First off, fix your indenting in your code it will make it much easier to read. I recommend finding and following a coding standard. This is a good one http://alltasks.net/code/php_coding_standard.html

Secondly, it would probably be better to read all the software's into an array then you could execute a single delete query like this

<?php
$sql = "DELETE FROM bksoftware WHERE software NOT IN ('" . implode("','",$softwares) . "')";
mysql_query($sql);
?>

tsukey

Ok....I will try to indent my codes. But now, this is part of a school attachment project. There is not much time left to complete it and I am doing alone. So, maybe not be able to do much.

Regarding ur suggestion, I try to implement it, but nothing happened. It did not delete anything.

tsukey

Anyway...this is what I have edited:

  //$sql = "Select software From bksoftware";
                //$result = mysql_query($sql) or die(mysql_error());
                //while ($row = mysql_fetch_assoc($result)) {
                //if ( !(in_array($row['software'], $software2nd))) {
                //       $sqldelete = "Delete from bksoftware where software !='" . $row['software'] . "'";
                //        $resultdelete = mysql_query($sqldelete) or die(mysql_error());
                //        }
                //}
                //Delete records of software removed from text file

            $sql = "DELETE FROM bksoftware WHERE software NOT IN ('" . implode("';'",$software2nd) . "')";
            mysql_query($sql);

drawmack

replace implode("';'" with implode("','"