PHP Code:

$sql = 'ALTER TABLE `$dbprefixuser` ADD `test` CHAR(1) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL;'; 


I am trying to get this to work, i need to have the variable $dbprefix inserted right before the word "user". Please help


thanks

Use the . operator to concatenate strings:

PHP Code:

$sql = 'ALTER TABLE `'. $dbprefix . 'user` ADD `test` CHAR(1)...'; 


thanks

i am trying to do the same in another statement, but i just get error: table does not exist, here is my code:

PHP Code:

$query="SELECT * FROM `'. $dbprefix . 'user` WHERE user_name='$search';"; 


It's your quotes. Try this:

PHP Code:

$query='SELECT * FROM `'. $dbprefix . 'user` WHERE user_name='$search';';