title: Cannot create MySQL table with "if not exists"
body: <p>Here is my code:</p>
  
  <p><code>$STH1000=$DBH->query("CREATE TABLE IF NOT EXISTS '".$dept.$year."' ( `ID` INT( 255 ) NOT NULL AUTO_INCREMENT , `URL` VARCHAR( 255 ) NOT NULL , PRIMARY KEY ( `ID` )) ")
  or die "Could not prepare sql statement";</code></p>
  
  <p>All I'm trying to do is create a table if $dept$year doesn't exist but the way I have it now, it throws errors.</p>
  
  <p>I believe there is a way to create a table is mysql returns an error on a select but I'm not sure how to do that either. Any help would be greatly appreciated.</p>