I'm working on a form application that I plan to use as a basis for the contact form extension I'm working on. (the login would be removed, as MediaWiki would provide the user accounts)
There's a problem that I get when I try to run the script for creating the database tables.
This is the page that has the script: ($dbprefix is just for this application, I'll change it to the one MediaWiki uses when I make the extension. I believe I may have entered that right)
// Get user account information from installation form
$new_admin_username = trim($_REQUEST['new_admin_username']);
$new_admin_password = trim($_REQUEST['new_admin_password']);
// Create the user table
$create_user_table = "
mysql> CREATE TABLE /*$dbprefix*/users (
-> user_id int AUTO_INCREMENT PRIMARY KEY,
-> username varchar(30) NOT NULL,
-> password varchar(30) NOT NULL
// Create table for storing messages
$create_message_table = "
mysql> CREATE TABLE /*$dbprefix*/messages (
-> message_id int AUTO_INCREMENT PRIMARY KEY,
-> sender_name varchar(50) NOT NULL,
-> sender_email varchar(50) NOT NULL,
-> sender_message varchar(2000) NOT NULL
// Create user account
$new_admin_create_account = "
mysql> INSERT INTO /*$dbprefix*/users (username, password)
Here's the 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 'mysql> CREATE TABLE /**/users ( -> user_id int AUTO_INCREMENT ' at line 1
This post was posted by Lieutenant S. Reznov, but signed as Inquisitor Ehrenstein.