PHP - Problems With Deleting Rows

I'm trying to delete rows in the database, based on what checkboxes are left empty by the user...

What i have is small application in which a user can add an item to the database and give it tags...

for example there is "apple" and it has the tags of "fruit, red, round"

What i want is for the user to be able to edit those tags, so the user can remove "fruit" and add "sweet" instead or just remove "fruit" all at the same time.

The code i have, somewhat works...

This code below loops through the checkboxes and should remove the items that are no longer checked, by going through the database and grabbing all the tags and them checking it against those that are still checked and remove the ones that it didn't find checked...??

However whats happening is when i unchecked say "red" it removes all the other items..so if i had "red, fruit, round' and i want to remove "red" it leaves red but removes the rest.

foreach($_POST['tag'] as $r=>$n){
$t = mysql_real_escape_string($_POST['tag'][$r]);

$get_tag2 = mysql_query("SELECT * FROM file_cats WHERE fileID='$fileID'") or die(mysql_error());
while($t2 = mysql_fetch_assoc($get_tag2)){
$tmp_tag1 = $t2['category'];

if($t==$tmp_tag1){
$remove_tag = mysql_query("DELETE FROM file_cats WHERE fileID='$fileID' AND category='$t' LIMIT 1") or die(mysql_error());
}
}
}


This following piece of code just adds a new tag...however i want it to check to see if that tags already exist in the database, if it does then don't add it just add the new ones..


foreach($_POST['tag'] as $k=>$l){
$tag = mysql_real_escape_string($_POST['tag'][$k]);

$add_tag = mysql_query("INSERT into file_cats (fileID, category) VALUES('$fileID', '$tag')") or die(mysql_error());

}


My final problem is that i can't remove items if the second snippet of code is there, i have to remove those lines of code in order to remove items, however i can add items with both loops there.

I'm basically stuck and hope that someone here can shed some light on what i'm doing wrong, because i know i'm doing something wrong i just can't find it

Anyway thank you in advanced

Ok I am trying to delete some rows from a database. I have done this before with success so I thought I could use the same method just modify it a little and it would work. Man was I wrong. Any help on this is much appreciated below is my code.

Code for the Query to get the data from the database and for displaying the results in a table:
Code: [Select]

//GET DATA
$sql = "SELECT * FROM `".$tblname."` ORDER BY $orderby $sort LIMIT $startrow,$limit";
$result = mysql_query($sql) or die(mysql_error());
$result2 = mysql_query($sql);

//START TABLE AND TABLE HEADER
echo "<form name='form1' method='post' action=''><table style='font-size:9.5px;'>\n<tr><th>Delete</th>";
$array = mysql_fetch_assoc($result);
foreach ($array as $key=>$value) {
if($config['nicefields']){
$field = str_replace("_"," ",$key);
$field = ucwords($field);
}

$field = columnSortArrows($key,$field,$orderby,$sort);
echo "<th>" . $field . "</th>\n";
}
echo "</tr>\n";

//reset result pointer
mysql_data_seek($result,0);

//start first row style
$tr_class = "class='odd'";

//LOOP TABLE ROWS
while($row = mysql_fetch_assoc($result)){


echo "<tr ".$tr_class.">\n<td><a
 href='remove_rec.php?id=". $rows['ID'] . "'><p>Delete</p></a>";
echo "</td>";
foreach ($row as $field=>$value) {
echo "<td>" . $value . "</td>\n";
}
echo "</tr>\n";
//switch row style
if($tr_class == "class='odd'"){
$tr_class = "class='even'";
}else{
$tr_class = "class='odd'";
}

}

//END TABLE
echo "</table>\n</form>";

Here is the code that should delete the row:
Code: [Select]
$tblname = 'tablename';
// get value of id that sent from address bar
$id=$_GET['ID'];

// Delete data in mysql from row that has this id
$sql="DELETE FROM $tblname WHERE ID='$id'";
$result=mysql_query($sql);

// if successfully deleted
if($result){
echo "Deleted Successfully";
echo "<BR>";
echo "<a href='leads3.php'>Back to Results</a>";
}

else {
echo "ERROR";
}

When I click on the link to delete a record it redirects me to the appropriate page with the "Deleted Successfully" message but when I go to view the results the row was not deleted. Any help on this would, again, be greatly appreciated.

How would I make a script that would delete any row in a MySQL table that was more than 7 days old?

I have a mysql table that looks like this:

id int(11) autoincrement
artist varchar(50)
title varchar(50)

I need to check for any rows that have the same titles.
So for example, if I had the following rows:

1 - Bob - Hello World
2 - Charlie Brown - Theme Song
3 - Joe - Hello World
4 - Joe - Is Cool
5 - Bob - Magic Dude

The query would display Row 1, and Row 3 as duplicates. Any idea how I can do something like this?

I really need some huge help on deleting rows with check boxes. Im completly lost on how to do this. Read some examples online and even with the code being small to do this i cant figure it out on intergrading it with the code I wrote. sorry that the code is long on this. I have decent comments though. At the very bottom i have started writing the delete code. My problem is figuring out how to make the script know what check box is checked. I have a select all check box  java script on this page too



Code: [Select]
<form name="frm1" id="frm1" action="" method="post" 
15.onsubmit="javascript:return submitIt('frm1')">
  <p>
  <center>


    <table width="60%" border="1" cellspacing="1" cellpadding="0">
      <tr align="center">
       
      </tr>
      <tr align="center">
        <td><input type="checkbox" name="checkAll" value="x" id="checkall" onclick="checkUncheckAll('association[]', this.checked)" /></td>
        <td>Recipient</td>
        <td>Subject</td>
        <td>Sent</td>
        <td>read/unread</td>
        </tr>
<?php 



// find out how many rows are in the table 
$count3 = "SELECT  COUNT(*) FROM sent WHERE id = '".($_SESSION['user_id'])."'";;
$count2 = mysql_query($count3) or trigger_error("SQL", E_USER_ERROR);
$r = mysql_fetch_row($count2);

$numrows = $r[0];

// number of rows to show per page
$rowsperpage = 10;
// find out total pages
$totalpages = ceil($numrows / $rowsperpage);


// get the current page or set a default
if (isset($_GET['sent']) && is_numeric($_GET['sent'])) {   

// cast var as int   
$currentpage = (int) $_GET['sent'];
} else {   
// default page num   
$currentpage = 1;
}// end if


// if current page is greater than total pages...
if ($currentpage > $totalpages) {   
// set current page to last page   
$currentpage = $totalpages;
}// end if

// if current page is less than first page...
if ($currentpage < 1) {   
// set current page to first page   
$currentpage = 1;

} // end if

// the offset of the list, based on current page 
$offset = ($currentpage - 1) * $rowsperpage;

// get the info from the db 
$count3 = "SELECT * FROM sent WHERE id = '".($_SESSION['user_id'])."' ORDER BY time DESC LIMIT $offset, $rowsperpage ";
$count2 = mysql_query($count3) or trigger_error("SQL", E_USER_ERROR);
// while there are rows to be fetched...
while ($list = mysql_fetch_assoc($count2)) {   
// these are variables to place in the echo
$sent_id = $list['sent_id'];
$recipient = $list['sendto'];
$subject = $list['subject'];
$read = $list['read'];


// grabs the time offset
$take3 = "SELECT time_offset FROM users WHERE id='".mysql_real_escape_string($_SESSION['user_id'])."'"; 
$take2 = mysql_query($take3) or die(mysql_error());
$take1 = mysql_fetch_array($take2);

$recieved = $list['time'];
// adds the users time offset to the inputed time
$time = ($recieved + $take1['time_offset']);
// sets default time to UTC then formats the inputed time that was offset with the users offset
date_default_timezone_set('UTC');
$user_offset = date('h:i:s a  M/d', $time);  

?>



<tr>
      <td><center><input type="checkbox" name="association[]" id="<?php echo $sent_id; ?>" value="1" /></center></td>

    </label></td>
       
    <td><center><a href="search_goaulds.php?goauld=<?php echo $recipient; ?>"><?php echo $recipient ?></a></center></td> 
   
       <td><center><a href="sent_view.php?sent_id=<?php echo $sent_id; ?>"><?php echo $subject ?></a></center></td>
   
       <td><center><?php echo $read ?></center></td> 
 
       <td><center><?php echo $user_offset ?></center></td>
   
     
    </tr>
     
        <?php } // while loop 
        ?>
    </table>

  </center>



<div class="deletecontainer">
<div class="delete">
<br/>
<input type="submit" name="delete" id="delete" value="Delete"></p>
</form>
</div>
</div>
<?php


if(isset($_POST['delete'])) {

                                         // if checkbox is checked with the matching sent_id
if(isset($_POST['sent_id'])) {

                                                                                      // then delete sent_id matching the checkbox id
                       mysql_query("DELETE FROM `sent` WHERE `sent_id`= '".($_POST['sent_id'])."'");




}
}

?>