title: Seems to be a syntax error in my MySQL
body: <p>MySQL is putting off the following error:</p>
  
  <pre><code>You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'CREATE TABLE IF NOT EXISTS `badips` ( `id` int(10) NOT NULL auto_increment, ' at line 2
  </code></pre>
  
  <p>When I run the following PHP:</p>
  
  <pre><code>if (file_exists("../login/includes/config.php")) {
  
      $db_schema = array();
  
  $db_schema[] = "DROP TABLE IF EXISTS `badips`;
  CREATE TABLE IF NOT EXISTS `badips` (
    `id` int(10) NOT NULL auto_increment,
    `host` varchar(50) NOT NULL,
    `ip` varchar(20) NOT NULL,
    `enteredhost` varchar(50) NOT NULL,
    PRIMARY KEY  (`id`)
  ) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=26 ;";
  
  require_once('../login/includes/config.php');
  require_once('open-db.php');
  
        echo "&lt;h3&gt;Creating tables...&lt;/h3&gt;";
        foreach($db_schema as $sql) {
         mysql_query($sql) or die(mysql_error());
        }
        echo "&lt;h3&gt;Done!&lt;/h3&gt;";
    }
  </code></pre>
  
  <p>But when I run the same SQL from PHPMyAdmin, it works without any flaws. I can't figure out what the problem is. Anyone know?</p>