Trouble with DATE field and date/strtotime conversion

[eluser]elambert[/eluser]
Sorry about that...

Code:

function get_by_user_id( $id )
{
  $this->db->where( ‘users_user_id’, (int)$id );
  $query = $this->db->get( ‘profiles’ );
  if ( $query->num_rows() > 0 )
  {      
    $row = $query->row_array();  
    $row[ ‘profile_date_birth’ ] = date( ‘m-d-Y’, strtotime( $row[ ‘profile_date_birth’ ] ) );        
  }
  return ( $query->num_rows() > 0 ) ? $row : FALSE;
}

In the model, I update a record with this function:

function update( $id, $data )
{
  $data[ ‘profile_date_birth’ ] = date( ‘Y-m-d’, strtotime( $data[ ‘profile_date_birth’ ] ) );              
  $this->db->where( ‘profile_id’, (int)$id );
  $query = $this->db->update( ‘profiles’, $data );        
  return ( $query ) ? TRUE : FALSE;                
}

When I run your code it produces: 2000-02-01