[SOLVED] help with my code

[jber]

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

 

[phat_hip_prog]

You might need some more spaces...

e.g.

:::Your version:::

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

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

[gerkintrigg]

and some quotes... either ` or ' (and yes, there is a difference).

[jber]

 

the spaces!!! thanks a lot!!!!!!!

 

Jorge