Creating MySQL table names from input

[jase35750]

Hi folks. I need an example of PHP4.0 code that will create a MySQL table "name" based on the user's input. I've done research and can find no examples using "CREATE TABLE $Name ();

The only examples I can find are "prenamed" tables with the field definitions.

I want the user to be able to name the table based on his input.

For instance:
Project Name input:" Project 6";
Create table Project 6 (

I need this procedure so that the database can add new seperate tables based on new projects as they are developed.

[maxholman]

You'll need to define at least 1 field when creating a table.

$sql = "CREATE TABLE '$table_name' ('a_unique_field_name' FIELDTYPE(length))";

FIELDTYPE and length are replaced with the values you want.