I've tried everything... now it's the last resort: seeking help here. I've got a create table query for MySQL but it's not creating. Can someone point out what's wrong? Thanks.
And yes, I did define and log into the database properly: the script handles other stuff from that table as well and that works fine, it's just creating this table that's the problem.
Thanks.
| Code: |
| $querycreate = <<<STRING
CREATE TABLE 'lottery_users' ( 'id' INT(11) NOT NULL AUTO_INCREMENT, 'username' VARCHAR(25) NOT NULL, 'tickets' TINYINT(2) NOT NULL, PRIMARY KEY ('id'), INDEX ('tickets'), UNIQUE ('username') ) STRING; mysql_query($querycreate); |
And yes, I did define and log into the database properly: the script handles other stuff from that table as well and that works fine, it's just creating this table that's the problem.
Thanks.
