PHP - Finding The Best Result

I am really lost here with this date issue of mine. The below code is the last part of a query:
Code: [Select]
$defendercheck_3 = $row_checkifattacked3['atdate'];
$defendercheck1_3 = strtotime("$defendercheck_3");
$defendercheck2_3 = date("D", $defendercheck1_3);
The query does not return any results as expected, but when echoing the various steps I get following:

echo "$defendercheck3"; = nothing (as expected)

echo "$defendercheck1_3"; = nothing (as expected)

echo "$defendercheck2_3"; =  result! (NOT expected)

why does it return anything on "date("D", $defendercheck1_3)" when "$defendercheck1_3" is blank?

Hi

I have a file, that is copied from other files. All other files work perfectly.
But, for some reason this one is throwing back an error.

I've been over it so many time, but can't see whats wrong.

Error:
Fatal error: Call to undefined method stdClass::save() in /home/p/o/powtest/web/public_html/admin/lib/ajax_php/add_interests.php on line 28


add_interests.php
Code: [Select]
<?PHP
require_once("../../../includes/initialize.php");

$flag = 0;
$ID = $_POST['ID'];
$type = $_POST['type'];
$category = $_POST['category'];
$interest = $_POST['interest'];
$expInt = explode("\n", $interest);
$DMOD = date('Y-m-d');
$TMOD = date('H:i:s');

$check_entry = Admin_interest::if_exists(clean_input_value($category));
if($check_entry == 0){
$new_category = Admin_interest::make($ID, clean_input_value($category), clean_input_value($type), $DMOD, $TMOD);
if($new_category && $new_category->save()){
$CID = $new_category->id;
$flag = 1;
}
}


foreach($expInt as $expInts){

$check_entry = Admin_interests_sub::if_exists($CID, clean_input_value($expInts));
if($check_entry == 0){
$new_interest = Admin_interests_sub::make($ID, $CID, clean_input_value($expInts), $DMOD, $TMOD);
if($new_interest && $new_interest->save()){
$message = 'Thank You: Your list Has Been Saved';
}else{
$message = "Sorry, There was an error";
}
}

}

echo $message;
?>


Class:
Code: [Select]
<?PHP
require_once(LIB_PATH.DS.'database.php');

class Admin_interests_sub {

protected static $table_name="admin_interests_sub";
protected static $db_fields = array('id', 'category_id', 'interest_sub', 'dateMod', 'timeMod');
public $id;
public $category_id;
public $interest_sub;
public $dateMod;
public $timeMod;


public static function make($ID, $category_id, $interest_sub, $DMOD, $TMOD){
if(!empty($interest_sub)){
$interest = new Admin_interests_sub();
$interest->id = (int)$ID;
$interest->category_id = (int)$category_id;
$interest->interest_sub = $interest_sub;
$kw->dateMod = $DMOD;
$kw->timeMod = $TMOD;
return $kw;
}else{
return false;
}
}

protected function attributes(){
$attributes = array();
foreach(self::$db_fields as $field){
if(property_exists($this, $field)){
$attributes[$field] = $this->$field;
}
}
return $attributes;
}

protected function sanitized_attributes(){
global $database;
$clean_attributes = array();
foreach($this->attributes() as $key => $value){
$clean_attributes[$key] = $database->escape_value($value);
}
return $clean_attributes;
}

public function save(){
return !empty($this->id) ? $this->update() : $this->create();
}

public function create(){
global $database;
$attributes = $this->sanitized_attributes();
$sql = "INSERT INTO ".self::$table_name." (";
$sql .= join(", ", array_keys($attributes));
$sql .= ") VALUES ('";
$sql .= join("', '", array_values($attributes));
$sql .= "')";
if($database->query($sql)){
$this->id = $database->insert_id();
return true;
}else{
return false;
}
}

public function update(){
global $database;
$attributes = $this->sanitized_attributes();
$attribute_pairs = array();
foreach($attributes as $key => $value){
$attribute_pairs[] = "{$key}='{$value}'";
}
$sql = "UPDATE ".self::$table_name." SET ";
$sql .= join(", ", $attribute_pairs);
$sql .= " WHERE id=".$database->escape_value($this->id);
$database->query($sql);
return ($database->affected_rows() == 1) ? true : false;
}

public function delete(){
global $database;
$sql = "DELETE FROM ".self::$table_name." ";
$sql .= "WHERE id=".$database->escape_value($this->id);
$sql .= " LIMIT 1";
$database->query($sql);
return ($database->affected_rows() == 1) ? true : false;
}

}

?>


Any help finding this bug will be a big help.

Thanks

Okay I'm done with searching for answers, working on this preg_match for about 3 hours now.   I'm looking for "($0.01/$0.02 USD)" in a string. The needle might be slighty different. Possible strings that I might look for is:

(€xx.xx/€xx.xx EUR) where the EUR can be changed into USD, including its signs.

What I want to be able to do is this:

If I have a list of values in my database:

1
13
26
15
12
4

I do a query of this database and sort it asc so it looks like this:

1
4
12
13
15
26

I want to know how I can use php and/or sql query to find these values based off of "position" in the list.

If I wanted the 3rd value in the list, that value would be 12.  If i wanted the 2nd value in the list it would be 4.  How would I go about doing this?

Thank you in advance.

Im trying to find the time between the last database entry and the current time and then echo it so it says something like '2 minutes ago'. I tried doing:

$last_post_gap = strtotime('NOW') - strtotime($topic_info->topic_last_post_time);
$last_post_gap = date('i', strtotime($last_post_gap));
$last_post = date('F j, Y', strtotime($topic_info->topic_last_post_time));


if ($last_post <= '- 1 DAY') 
{ 
$last_post = 'Yesterday at '.date("g:i a", strtotime($topic_info->topic_last_post_time)); 
}
if ($last_post <= '- 1 MINUTE') 
{ 
$last_post = 'Less Than 1 Minute Ago'; 
}
else
{
$last_post = $last_post_gap.' Minutes Ago';
}

but that just displays 0 minutes ago regardless of the time.

Is there anything im missing?