alfa24, thanks for the help so far. The function for toggling the date finished directly after the set date finished function we discussed:
public function toggleDateFinished($id_date, $id_user)
{
$query = "UPDATE ".$this->user_date_table
." SET date_complete = '0000-00-00 00:00:00'"
." WHERE id_date = ".$id_date
." AND id_user = ".$id_user;
return sql_query($query);
}
I can see no reason to zero the date? Null would be more suitable? Would the NULL value cause issues in the view part? I cannot see why.