PHP - Moved: Deleting Old Records

This topic has been abducted by aliens, probed, and dropped off in JavaScript Help

http://www.phpfreaks.com/forums/index.php?topic=359251.0

This topic has been moved to MySQL Help.

http://www.phpfreaks.com/forums/index.php?topic=309981.0

This topic has been moved to MySQL Help.

http://www.phpfreaks.com/forums/index.php?topic=356136.0

This topic has been moved to MySQL Help.

http://www.phpfreaks.com/forums/index.php?topic=325939.0

This topic has been moved to MySQL Help.

http://www.phpfreaks.com/forums/index.php?topic=311502.0

This topic has been moved to MySQL Help.

http://www.phpfreaks.com/forums/index.php?topic=308916.0

I am having trouble showing reports for a given date range. Currently if I specify something like 11/03/2010 to 11/05/2010 I get results for all years within that month and day such as I may get results for 11/03/2008 11/03/2009 11/03/2010 11/04/2008 11/04/2009 11/04/2010 11/05/2008 11/05/2009 11/05/2010.
I am using the following code
$result = mysql_query("SELECT * FROM report WHERE date>='$date_begin' and date<='$date_end' ORDER BY 'date'",$db);

I use the following format in my date feild mm/dd/yyyy

My script is finally working as intended, but I want to add some additional data results.

I am trying to resolve how I can display a count of ONLY the records updated by my query:

// START :: Query to replace matches
mysql_query("UPDATE orig_codes_1a AS a
      JOIN old_and_new_codes_1a AS b ON concat(a.orig_code_1, a.orig_code_2) = concat(b.old_code_1, b.old_code_2)
   SET a.orig_code_1 = b.new_code_1,
                           a.orig_code_2 = b.new_code_2") or die(mysql_error());
// END :: Query to replace matches


In this query I count ALL records selection:


// START :: Create query to be displayed as final results of original codes table.
$result = mysql_query("SELECT * FROM orig_codes_1a") 
or die(mysql_error());  

I want to display a count on this part of the query:

....concat(a.orig_code_1, a.orig_code_2) = concat(b.old_code_1, b.old_code_2)....

Could anyone tell me why this is not deleting the userip and post id from the database at all.

Thanks


Code: [Select]
<?php
include('dbcon.php');

if($_REQUEST['postId'])
{
$userip = $_SERVER['REMOTE_ADDR'];

mysql_query("update collapsed_likes set likes=likes-1 where post_id= ".$_REQUEST['postId']);

mysql_query("delete from collapsed_ip where userip=".$userip." AND post_id = ".$_REQUEST['postId']);

$total_likes = mysql_query("SELECT * FROM collapsed_likes where post_id = ".$_REQUEST['postId']." ");
$likes = mysql_fetch_array($total_likes);
$likes = $likes['likes'];
}
echo $likes;
?>

I'm just trying to get suggestions on what people think would be the best way to go with this. With the bottom part of this card where it s tarts working with the foreach loop its taking what was a UL and for each of each LI's and updating a table with its new data however this way isn't going to work as this is editing a user. Because there could be 5 in the database but the new edit user has only 4 lis so I'm sure you could all see the issue here. What I'm thinking would be best is to have it DELETE the existing characterIDs that have WHERE handler_ID = $handlerID and then just do a new INSERT statement. Anyone else think this would be the best way to go about this?


Code: [Select]
if (mysqli_num_rows($Qresult) == 0) {
        $query = "UPDATE `handlers`
            SET `userName` = '".$userName."', `password`='".$password."', `firstName`='".$firstName."', `lastName`='".$lastName."', `statusID`='".$statusID."', `isAdmin`='".$admin."', `defaultCharID`='".$defaultCharID."', `email`='".$email."' WHERE `ID` = '".$handlerID."'"; 
        mysqli_query($dbc, $query);
        foreach ($characterIDs as $cID) {
               $query2 = "UPDATE `handler_characters`
               SET `handler_id` = '".$handlerID."', `characterID` = '".$cID."'";
               mysqli_query($dbc, $query2);
        }
        $result = "good";
    }

Does anyone have a code that will automatically delete stuff out of the database after 30 days of being in there...?

I'm trying to delete the <identifier> node of some XML, using the following code; unsuccessfully.   Can someone help me identify where I'm going wrong? TIA

$newXML = "";
$xmlString = Fedora_API::callGetDatastreamContents($this->pid, 'MODS', true);
$doc = DOMDocument::loadXML($xmlString);
$xpath = new DOMXPath($doc);

$fieldNodeList = $xpath->query("/identifier");

foreach ($fieldNodeList as $node) {  
	$fieldNodeList->removeChild($node);
}
$newXML = $doc->SaveXML();  

I am sorry even i didn't say hello to forum but i need this snippet very urgently. i have Zero knowledge of PHP but unfortunately i need a small code as follow.

Hi, this is the first time I've asked for some help from a forum. I guess this code has sort of got me stumped.

So, I have a system where a user can enter a number. The number goes into a mysql database. A random number is also generated and it is added into another column.

So, I want users to be able to delete the number using the random number. I've shown it to them, and I need help working my delete script.
Code: [Select]
<?php
$con = mysql_connect("localhost","","");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_select_db("a8784hos_adopts", $con);
$adopt = $_POST['adoptid'];
$uniquecode = $_POST['uniquecode'];
$result = mysql_query("SELECT uniquecode, id FROM id WHERE id='$adopt'");
mysql_fetch_array($result);
if (($adopt == $row['id']) || ($uniquecode == $row['uniquecode'])){
mysql_query("DELETE FROM id WHERE id='$adopt'");
echo 'Done! <br/><br/><a href="tester.php">Go back....</a>';
}
else {
echo 'Bad unique code. <br/><br/><a href="tester.php">Go back....</a>';
}
?>

So, the random number is uniquecode in the database, and the number is id. However, when I try this code, it always tell me I have a bad unique code. What am I doing wrong?

Thanks.