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;
}
예제 #2
0
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;
}