php forms

[Anon]

I have an input field that when submitted is supposed to create a mysql table.

create_table.html

<form action="table.php">
<input type="text" name="tbinfo" value="CREATE TABLE "> <input type="submit">
</form>

table.php

mysql_connect($host, $user, $pass);
mysql_select_db($database);
mysql_query($tbinfo);
mysql_close();

now, when i put in the field : CREATE TABLE something(rowid INT, email CHAR(255))

and submit it, it works fine and creates it.

Now if I do the same thing, but add :

CREATE TABLE something(rowid INT AUTO_INCREMENT PRIMARY KEY, email CHAR(255))

it doesn't work.

What do I do?

[brandonschnell]

what is the error message?

[Anon]

it didn't give me an error message.

It just gave me a blank screen, so i created a custom error message saying it failed

if (!(mysql_query($tbinfo))) {

echo "error";
}

[Anon]

sorry, someone else used this computer before and I forgot to change the name and email address.

[Anon]

guessing i.e not tried it , but PRIMARY KEY should be set after the rest of the info, so for your example...

CREATE TABLE table (rowid INT(10) NOT NULL auto_increment,email char(255) NOT NULL,PRIMARY KEY (rowid))

or something along those lines, also use
echo mysql_error(); to get a better error message.

[georgen]

I don't have any problem. Probably you don't have the last version of MySQL. I have 3.23.35 and i don't have any problem wih your script.

[sanand158]

Another convienient way of getting the SQL right is to use PhpMyAdmin. Use this application to create tabels, databases and modify records. After executing the command, the full SQL statement is displayed. Copy this command into your PHP script.