[SOLVED] Mysql - problem with quotes!!

[shotos]

hi all,

trying to run a mysql query and i seem to have messed up with the quotes.

so i get a syntax error on the query command

 

$rename = 'alter table Element_'.trim($title).' change ' . $column_name  $check_item . ' varchar(50)';

 

tanx in advance

[ohdang888]

post your error and the whole query

[shotos]

the error is:

 

Parse error: syntax error, unexpected T_VARIABLE in /home/kwasi/public_html/modify_update.php on line 39

 

the code is

$column_name = $_SESSION['column_name'];
	$rename = 'alter table Element_'.trim($title).' change ' . $column_name  $check_item . ' varchar(50)';
                         
	$update = mysql_query($rename,$db->link) or die(mysql_error() . " Query was: $rename");

[ohdang888]

$column_name = $_SESSION['column_name'];	
$rename = 'alter table Element_'.trim($title).' change '.$column_name.$check_item.' varchar(50)';
                         
$update = mysql_query($rename,$db->link) or die(mysql_error() . " Query was: $rename");

 

try it

[shotos]

it didn't work.

this was the error

 

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server

version for the right syntax to use near 'varchar(50)' at line 1

Query was: alter table Element_Trial change babybaby varchar(50)

[shotos]

it didn't work.

this was the error

 

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server

version for the right syntax to use near 'varchar(50)' at line 1

Query was: alter table Element_Trial change babybaby varchar(50)

[moselkady]

 

A small fix to ohdang888's solution:

 

$rename = 'alter table Element_'.trim($title).' change '.$column_name.' '.$check_item.' varchar(50)';

 

 

[moselkady]

 

One other thing, try to print $rename (or whatever you sql variable) in case you get an error to better figure out the problem.

[shotos]

finally it worked.

thanks