CREATE TABLE table_name_26 (president VARCHAR(255), treasurer VARCHAR(255), season VARCHAR(255))
Name the  President who has a Treasurer of james davidson, and a Season of 2006–2007?
    
SQL: SELECT president FROM table_name_26 WHERE treasurer = "james davidson" AND season = "2006–2007"