PHP - Deleting Rows With Same Value In A Single Column

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

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'])."'");




}
}

?>

Hi guys,

I am trying out this code but it does not work, any idea what I am doing wrong?

<?php
include 'connect.php';
$tbl_name="users";

$sql="SELECT * FROM $tbl_name";
$result=mysql_query($sql);

$count=mysql_num_rows($result);

?>
<table width="400" border="0" cellspacing="1" cellpadding="0">
<tr>
<td><form name="form1" method="post" action="">
<table width="400" border="0" cellpadding="3" cellspacing="1" bgcolor="#CCCCCC">
<tr>
<td bgcolor="#FFFFFF">&nbsp;</td>
<td colspan="4" bgcolor="#FFFFFF"><strong>Delete multiple rows in mysql</strong> </td>
</tr>
<tr>
<td align="center" bgcolor="#FFFFFF">#</td>
<td align="center" bgcolor="#FFFFFF"><strong>Id</strong></td>
<td align="center" bgcolor="#FFFFFF"><strong>Firstname</strong></td>
<td align="center" bgcolor="#FFFFFF"><strong>Lastname</strong></td>
<td align="center" bgcolor="#FFFFFF"><strong>Location</strong></td>
<td align="center" bgcolor="#FFFFFF"><strong>Email</strong></td>
<td align="center" bgcolor="#FFFFFF"><strong>Website</strong></td>
</tr>
<?php
while($rows=mysql_fetch_array($result)){
?>
<tr>
<td align="center" bgcolor="#FFFFFF"><input name="checkbox[]" type="checkbox" id="checkbox[]" value="<? echo $rows['id']; ?>"></td>
<td bgcolor="#FFFFFF"><? echo $rows['userID']; ?></td>
<td bgcolor="#FFFFFF"><? echo $rows['firstname']; ?></td>
<td bgcolor="#FFFFFF"><? echo $rows['lastname']; ?></td>
<td bgcolor="#FFFFFF"><? echo $rows['location']; ?></td>
<td bgcolor="#FFFFFF"><? echo $rows['email']; ?></td>
<td bgcolor="#FFFFFF"><? echo $rows['website']; ?></td>
</tr>
<?php
}
?>
<tr>
<td colspan="5" align="center" bgcolor="#FFFFFF"><input name="delete" type="submit" id="delete" value="Delete"></td>
</tr>
<?

if($delete){
for($i=0;$i<$count;$i++){
$del_id = $checkbox[$i];
$sql = "DELETE FROM $tbl_name WHERE id='$del_id'";
$result = mysql_query($sql);
}


if($result){
echo "<meta http-equiv=\"refresh\" content=\"0;URL=showusers2.php\">";
}
}
mysql_close();
?>
</table>
</form>
</td>
</tr>
</table>

Hi,
I am having difficulty deleting rows in my table using check boxes. I have all the check boxes displaying for each row and a delete button below the table. However when i click on the delete button it isnt deleting the checked rows, i have displayed the code below that i am using;

Code: [Select]
<?php 
  



$result = mysql_query("SELECT * FROM contact ORDER BY msg_id ASC");

echo "<table border='1'>
<tr>
<th>Delete</th>
<th>Message ID</th>
<th>Name</th>
<th>Email</th>
<th>Message</th>

</tr>";

while($row = mysql_fetch_array($result))
  {
  ?>
   <td align="center" bgcolor="#FFFFFF"><input name="checkbox[]" type="checkbox" id="checkbox[]" value="<?php echo $row['del_id']; ?>"></td>
   <?php
  echo "<td>" . $row['msg_id'] . "</td>";
  echo "<td>" . $row['name'] . "</td>";
  echo "<td>" . $row['email'] . "</td>";
  echo "<td>" . $row['msg'] . "</td>";
  echo "</tr>";
  }
echo "</table>";
?>
<td colspan="5" align="center" bgcolor="#FFFFFF"><input name="delete" type="submit" id="delete" value="Delete"></td>
</tr>


<?php
// Check if delete button active, start this 
if(isset($_GET['delete'])) {

for($i=0;$i<$count;$i++){
$del_id = $checkbox[$i];
$sql = "DELETE FROM contact WHERE id=".$_GET['del_id'];
$result = mysql_query($sql);
}

// if successful redirect to delete_multiple.php 
if($result){

}
}
mysql_close();
?>
Please help
Thank you

I want to delete rows in a table of my database using check-box.
Here are my codes below:

Code: [Select]
<?php
$con = mysql_connect('localhost', 'root', '') or die ('Connection Failed');
mysql_select_db('img', $con) or die ('Connection Failed');
$display = mysql_query("SELECT * FROM photos WHERE email='$lemail'");
echo '<input type="submit" value="Delete" name="del"/>';
echo "<table>
<tr>
<th>#</th>
<th>Images</th>
<th>Image description</th>
<th>Delete</th>
</tr>";
while($row = mysql_fetch_array($display))
{
echo "<tr>";
 echo "<td>".$row['img_ID']."</td>";
  echo "<td><img src='folder/".$row['imaged']."' alt='alt text' width='100' height='100' class='thumb'/> </td>";
echo "<td>".$row['image_description']."</td>";
echo '<td><input type="checkbox" name="delete[]" value="'.$row['img_ID'].'"/></td>';
echo "</tr>";
}
echo "</table>";
echo "</form>";
if (isset($_POST['delete'])) {
$del = $row['img_ID'];
for($i=0;$i<count($_POST["delete"]);$i++)
{
if($_POST["delete"][$i] != "")
{
$str = "DELETE FROM photos WHERE img_ID='$del' ";
mysql_query($str);
echo "Record Deleted.";
}
} 
}
mysql_close($connect);
?>
Here are the problems:

1/ Not working at all, I mean no image is being deleted
2/ At then end, I display a message that the record has been deleted, but if I check multiple checkbox, it keeps writing the message "Records deleted" multiple times

My images are stored in a folder while its details in database...

Help, thank you 

Hi, guys.
I am a php newb and stuck (see title).
I it will only send the value of 1 tick box over to the page "delete_message.php"

This is what i have so far:

Code: [Select]
<?php
// get messages
$result = mysql_query("SELECT * FROM tbl_pvt_msg WHERE to_UID='$UID'");
if (!$result) die("Query to show fields from table failed");
while ($data=mysql_fetch_array($result)) {

$_SESSION['from_UID']=$data['1'];
UIDtoemail();
$from_email=$_SESSION['from_email'];
$contents=$data['3'];
$timesent=$data['4'];
$msg_ID=$data['0'];
echo "<form action='scripts/delete_message.php' method='POST' >";
echo "<tr><td>$from_email</td><td>$contents</td><td>$timesent</td><td><input type='checkbox' value='$msg_ID' name='msg_ID' /></td> </tr>";
}
// turn uid into email
function UIDtoemail(){
$from_UID=$_SESSION['from_UID'];
$result = mysql_query("SELECT * FROM tbl_usr WHERE UID='$from_UID'");
if (!$result) die("Query to show fields from table failed");
$data=mysql_fetch_array($result);
$_SESSION['from_email']=$data['7'];

}
?>
</table>
<input type="submit" value="Delete" id="delete" />
</form>

Hi there im trying to set a single variable multiple rows of data that are echoed using a single variable. The trouble is i just cant seem to make it work by trying to add a while or do loop..

The variable is $alderaanfleetalt  and consists of:

Code: [Select]
$fleetname = "FleetName";
$shipname = "Ship Name";
Which is just text stored in two other variables. The select query row of data is added the $alderaanfleetalt variable.

Code: [Select]
$alderaanfleetalt =  $fleetname." ".$row_Alderaanfleet['FleetName']."</br>".$shipname." ".$row_Alderaanfleet['ShipName'];
At the moment only a single row appears. ive tried to add a while/do loop so that multiple rows are outputted but its not working.

Code: [Select]
do{
$alderaanfleetalt =  $fleetname." ".$row_Alderaanfleet['FleetName']."</br>".$shipname." ".$row_Alderaanfleet['ShipName'];
} while ($row_Alderaanfleet = mysql_fetch_assoc($Alderaanfleet));

Im a bit lost here and not even sure it can be done this way... Any help would be ace.

Thank you

how do I call only a single column in a MySQL?

This is not working.
$SomeVar = $_POST['finco'];
$query = "SELECT * FROM idb WHERE name = '".$SomeVar."'";
$results = mysql_query($query);
$psend = $results["fincos"];
echo($psend);

Hey, I was wondering if there is a way to pull multiple rows at once using a list of unique identifiers. For example, I want to pull the rows with the IDs of 4,13,91 and 252

I know the WHERE part of this query is incorrect, but I'm putting it to hopefully help you guys understand what I'm looking for.

$result = mysql_query("SELECT * FROM $table WHERE id='4' OR '13' OR '91' OR '252'");
while($row = mysql_fetch_array($result))
{
echo($row['name']);
}


Or is the best way simply to do it one query at a time without a while statement? There could be as many as a few dozen records being pulled per page.

Hi Everyone,

I am working on implementing a blog comment system using the query below to display comments. My question is what is the best way to do a row count for the id column with this query or do I need to do a second db query to accomplish this? The purpose of this is to echo out the number of comments for that post, before displaying them.

Any help is appreciated.

Thanks in advance,

kaiman


<?php
// get url variables
$post_id = mysql_real_escape_string($_GET['id']);

include ("../../scripts/includes/nl2p.inc.php");

// connects to server and selects database
include ("../../scripts/includes/dbconnect.inc.php");

// table name
$tbl_name3="blog_comments";

// select info from comments database
$result3 = mysql_query ("SELECT count(*) FROM $table_name3 WHERE id='$post_id' ORDER BY id DESC LIMIT 1") 
or trigger_error("A mysql error has occurred!");
if (mysql_num_rows($result3) > 0 ) {
while($row = mysql_fetch_array($result3)) {
extract($row);

// display number of comments


// display date
$row_date = strtotime($row['date']);
putenv("TZ=America/Denver");
echo "<p class=\post\">On ".date('F, jS, Y', $row_date)." ";

// display commenter name
if($row['url'] == "") { 
echo $row['name']." wrote:</p>\n"; 
} 
     else { 
echo "<a href=\"".$row['url']."\" target=\"_blank\">".$row['name']."</a> wrote:</p>\n"; 
} 

// display content
$comments = $row['comment'];
echo nl2p($comments);
}
}
else {
echo "<p class=\"large_spacer\">No Comments</p>";
}
?>

Hi all,

I've been using this code for a long time and realised it's very repetitive, but the id_column I want changes all the time


function getRows()
{
$query = mysql_query($sql);
$rows = array();

while($row = mysql_fetch_assoc($query))
{
$rows[$row['id_column']] = $row;
}

return $rows;
}


So I wrote this function that will automatically create an array with a column I choose if I wish, but I'm not sure if it's very efficient.


function getRows($query, $column_id = false)
{
$rows = array();

while($row = mysql_fetch_assoc($result))
{
if($column_id === false)
{
$rows[] = $row;
}
else
{
if(isset($row[$column_id]))
{
$rows[$row[$column_id]] = $row;
}
else
{
$rows[] = $row;
}
}
}

        return $rows;
}


I would appreciate some input as to make it better.
Thanks.

How to split the attribute-options after row 15 so it show attribute 1-15 than split the listing than show row 16-30 in a new column split again and show the next 15 attributes and list them in a new column?
Also how to remove the space (3 mm) between each row

Code: [Select]
echo '<tr><td><ul><li style="list-style: none; "><input type="text" name='.$i.'_quantity value="" style="text-align:right;" size="3">&ensp;';
 echo tep_draw_hidden_field($i.'_id[' . $products_options_name['products_options_id'] . ']', $products_options_array[$i]['id']) . $products_options_array[$i]['text'];  
echo "</li></ul></td></tr>";[code]

I have a bad way with words, so if the title doesnt make much sense nor my post, I apolagize!

But I am using a while loop and mysql_fetch_array to echo all information in a table in mysql.

With each entry, I have included a button that executes a delete query for that entry.

Code: [Select]
$delquery="DELETE FROM requests WHERE user = '".$row['user']."'";
mysql_query($delquery,$link2);
echo "<font size='19px' color='#009933'>User deleted from request database.When I click the button, the message is echod in every entry listed on the page, and nothing happens. I figured Id use delete from the username, so that way mysql will know which one to delete... but Idk when I think about it thats dumb and makes no sense. Im stuck.

This side of the application im trying to make is the admin side where I can process requests. After I process the request I delete it from the database so I know I processed it. I have no idea what query to use for this.

Anybody know how I could do this?

Thanks

Please help me. I'm fairly new to php and have been looking for answers on Goog for about two weeks or so with not an answer. This is my first post on a forum of any type.

I have a form on a php page that when submitted sends a value to a confirm php page

Code: [Select]
      <form action='buyconfirmorder.php' method='post'>
      Purchase: <input type='text' name='ask_shares'><br /><br />
      You Will Pay: &nbsp<input type='text' name='ask'><br /><br />
      <input type='hidden' name='postcardname' value='$postcardname'>
      <input type='submit' name='submit' value='Order'>
      </form>
I need to take the users input from the form and subtract each row from a mysql DB one at a time until the users input is down to a remainder and then I need the remainder (I'll be working with the remainder as well).

Code: [Select]
$query = mysql_query("
SELECT * FROM ask, search
WHERE search.id = ask.card_search_id
AND search.card_name = '$postcardname'
ORDER BY ask_price ASC");

The array will be numbers only.

So an example would be:

User input from the form is 100.00

Code: [Select]
   while($rows = mysql_fetch_array($query))
   {
   $ask_price = $rows['ask_price'];
   }
Let's say the array is 50.50, 40.50, 35.00

I need some code to do:

100.00 - 50.50 = 49.50
49.50 - 40.50 = 9.00
9.00 - 35.00 = <0 does not do anything
so remainder = 9.00

would it be something like
Code: [Select]
$new_ask_shares = $_POST['ask_shares'];
//some sort of a loop or array or combo of both
($new_ask_shares - $ask_price);
the numbers are just an example as the actual numbers will be different each time I query my DB.

Thanks in advance