php and alter table combination

Hello!

I have a problem with my application. I create a table , and i add a first column to it. Now i want to another column dinamically, only if i want.

So, in my script A i have :

<?php


echo 'Table to be modified : ' .$_SESSION["nomtab"]. '</br>';
$db = mysql_pconnect("localhost",$_SESSION["login"],$_SESSION["password"]);


echo 'Introduce new fields</br>';


echo '<form action="scriptB.php?" method="post">';

echo 'field name : <input type="text" size="20" maxlength="20" name="field2"> ';
echo ' field type : <input type="text" size="20" maxlength="20" name="type2"> </br>';
echo '<input type="submit" value="Add field"/>';

echo '</form>';

?>

In Script B i have

<?php
$field2 = $_POST["field2"];
$type2 = $_POST["type2"];

echo ' Field and type to add ' .$campo2. ' y ' .$tipo2.' a la tabla ' .$_SESSION["nomtab"]. '</br>';

$db = mysql_pconnect("localhost",$_SESSION["login"],$_SESSION["password"]);

$consulta = "ALTER TABLE" .$_SESSION["nomtab"]. "ADD" .$field2. " " .$type2."";

$resultados = mysql_query($consulta);
?>


It does not work, it does not add a new column to my table. I don´t know what is wrong, because i´ve followed rules
¿Can you help me?
Thanks in advance

 

solved!

It needed more spacing!

$consulta = "ALTER TABLE " .$_SESSION["nomtab"]. " ADD " .$campo2." ".$tipo2." "; is correct