Add a new column to mysql table

[kristian_gl]

Hello.

 

I am trying to add a new column to "table1" in Mysql database. I suspect that there is a syntax problem with my sql query. The closest I have been is, creating a new column with the name "$row1", opposed to the giving the column the name of the value with in the variable $row1. And yes, I have tried to echo out $row1 to verify that it's not empty.

 

$sql = "ALTER TABLE `table1` ADD ".$row1." VARCHAR(320) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL;";

mysql_query($sql);

 

Using:

PHP version: 5.2.11

Mysql version: 5.1.36

 

Kristian

[swatisonee]

$result = mysql_query[$sql] ;

[Mchl]

Does your MySQL user have privileges for ALTER statements?

[kristian_gl]

yes,  it does.

 

I have now made some progress, but i'm not there yet.

 

CODE:

while($row = mysql_fetch_array($result))

{

 

$row1 = $row[1];

 

$sql = 'ALTER TABLE `svar` ADD `  ' .$row1  .'` VARCHAR(320) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL';

$resultat = mysql_query($sql);

}

 

If I change the variable in the sql query to a $variable = "text string";it works, but not with $row1

 

[oni-kun]

You claim you echo'd $row1 yet you're now saying it does not work?

 

Also it is a very bad idea to have SQL statements within a loop, Use JOIN.

[kristian_gl]

Yes, I can echo out $row1

 

If I use a different variable such as $variable = "text string"; I get this sql query:

ALTER TABLE `svar` ADD ` text string` VARCHAR(320) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL (which works)

 

If I use $row1 I get this sql query:

ALTER TABLE `svar` ADD ` the content of row1` VARCHAR(320) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL (which does not work)

[swatisonee]

there is a space after the number 1 and before the dot 

 

.$row1  . 

[kristian_gl]

thanks for the help everybody, but I managed to figure it out. It was a syntax issue. here's the code that worked:

 

$sql2 = "ALTER TABLE `svar` ADD `$row1-` VARCHAR(320) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL";

$resultat = mysql_query($sql2);

 

for some reason I must put a character behind $row1, in order the get it to work,  this case I've used a "-", but it also works with other characters

[Mchl]

Perhaps there already was a column with this identifier in the table?