1:

mysql_query ("CREATE TABLE `".$spgem."` (

1: 
2: 
3: 
4: 
5: 
6: 
7: 
8: 
9: 
10: 
11: 
12: 
13: 
14: 
15: 
16: 
17: 
18: 
19:

if ($spgem == "")
			
{
echo "Keine Variable angegeben!";
}
else
{
			
mysql_query ("CREATE TABLE '$spgem' (
 `sg_id` INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY ,
 `z1` SMALLINT NOT NULL ,
 `z2` SMALLINT NOT NULL ,
 `z3` SMALLINT NOT NULL ,
 `z4` SMALLINT NOT NULL ,
 `z5` SMALLINT NOT NULL ,
 `z6` SMALLINT NOT NULL ,
 `lz_id` INT NOT NULL
) TYPE = MYISAM ;");
}