[RESOLVED] Head scratcher SQL syntax error

Albatross365

I can't fathom what's wrong with this

mysql_query("CREATE TABLE 'members'('id' INT(11) AUTO_INCREMENT, 'user' TEXT, 'password' CHAR(32), 'session_code' CHAR(32),PRIMARY KEY('id')") or die(mysql_error());

I get

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 '' at line 1

NogDog

Use back-ticks to quote field/table names, not 'single quotes'.

Albatross365

Using

mysql_query("CREATE TABLE `members`(`id` INT(11) AUTO_INCREMENT, `user` TEXT, `password` CHAR(32), `session_code` CHAR(32),PRIMARY KEY(`id`)") or die(mysql_error());

I still get the same error

NogDog

Your parentheses do not balance out, looks like you need a closing ")" at the end of the query.

Albatross365

Thanks. Knew it was something ridiculously easy.

Why can't it just say that?

NogDog

Albatross365;10984466 wrote:
Thanks. Knew it was something ridiculously easy.

Why can't it just say that?

Then anybody could be a database programmer, and we wouldn't make the big bucks any more. :rolleyes:

Albatross365

And people like me wouldn't come here 🙂