Hi,
I am adding an admin part to a site so the owner can add a new table for each property.
I have my form.... Very basic

<form action="createtable.php" method="post">
Name of house: <input type="text" name="name" size="20"> <input type="submit" name="submit" value="Submit"> </form>

and it should go to createtable.php... where the name of the property entered in the field in form comes out in this part

PHP Code:

<?php
$result="CREATE TABLE This is where name of table should be(
proname varchar(100) NOT NULL,
prostart date NOT NULL,
proend date NOT NULL,
promin enum('Semana', 'Fin de Semana', 'Tres Dias') NOT NULL,
prostatus enum('Libre', 'Ocupado') NOT NULL
)";

But i cant get the name to come up there.... NO IDEA... I have tryed echo.. print... everything. Im not sure i am carrying the info from one page to the other corrently and Im not sure as it is in a 'result' varible that it will work that way... If I write it in manually there... the table is created.

Please help!!
Thanks
Rachel

ok well since you put the input name="name", the variable you need would be $_POST['name']. i suggest changing it to something slightly more descriptive, like name="tablename", then you can use $_POST['tablename']

So this is what the could would look like:

PHP Code:

<?php
function sanitize($value) {
    $value = strip_tags($value);
    if(get_magic_quotes_gpc()) {
          $value = stripslashes( $value );
    }
    //check if this function exists
    if(function_exists("mysql_real_escape_string")) {
          $value = mysql_real_escape_string( $value );
    }
    //for PHP version < 4.3.0 use addslashes
    else {
          $value = addslashes( $value );
    }
    return $value;
}

$tablename = sanitize($_POST['tablename']);

$query = "CREATE TABLE $tablename (
proname varchar(100) NOT NULL,
prostart date NOT NULL,
proend date NOT NULL,
promin enum('Semana', 'Fin de Semana', 'Tres Dias') NOT NULL,
prostatus enum('Libre', 'Ocupado') NOT NULL
)";

$result = mysql_query($query);