function get_schools() { global $wpdb; $school_table_name = get_school_table_name(); // Get the schools out of the database $schools = $wpdb->get_results("SELECT * FROM " . $school_table_name . " wps "); return $schools; }
function build_school_sql() { $table_name = get_school_table_name(); $sql = 'CREATE TABLE ' . $table_name . ' ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(255) NOT NULL DEFAULT "", PRIMARY KEY (`id`) );'; return $sql; }