So, I'm trying to make a code to create a table, and I'm really new to mySQL. So I used phpMyAdmin for the code, and it gave me:
CREATE TABLE `$id` (
`Character` varchar(1) COLLATE latin1_general_cs NOT NULL,
`Code` varchar(2) COLLATE latin1_general_cs NOT NULL,
UNIQUE KEY `Character` (`Character`,`Code`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_cs
But it didn't work right, so I tried fixing it and got:
<?php
mysql_connect("localhost", "zyra_*******", "*****") or die(mysql_error());
mysql_query("CREATE TABLE $id (
Letter varchar(1) COLLATE latin1_general_cs NOT NULL,
Code varchar(2) COLLATE latin1_general_cs NOT NULL,
UNIQUE KEY Character (Character,Code)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_cs") or die (mysql_error());
?>
But then it started giving me a weird error. "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 '( Character varchar(1) COLLATE latin1_general_cs NOT NULL, Code varchar(2) COLLAT' at line 1" And I have no idea what to do. Please help!