WordPress.org

1. mostfamiliar
   Member
   Posted 4 years ago #

   I am trying to create a table for my plugin. When I check phpmyadmin -- I don't see the table listed, therefore assume the table hasn't been created. Here's my code:

   function immune_install () {
   global $wpdb;
   global $immune_db_version;

   $table_name = $wpdb->prefix . "release_list";
   if($wpdb->get_var("show tables like '$table_name'") != $table_name) {

   = $releasetable = "CREATE TABLE ". $table_name . " (
   id mediumint(9) NOT NULL AUTO_INCREMENT,
   release_title text NOT NULL,
   release_date mediumint(9) NOT NULL,
   release_label text NOT NULL,
   release_format text NOT NULL,
   release_link text NOT NULL,
   );";

   require_once(ABSPATH . 'wp-admin/includes/upgrade.php');
   dbDelta($releasetable);
   }
   }

   -------------------
   Thanks!!

Topic Closed

This topic has been closed to new replies.