add a new field to an exisiting table

Anon

I am trying to add a new field to an exisiting table in my database. I have tried and tried but nothing seems to be working. Could someone please be kind enough to check my code.

<?
include("dbpasses.inc.php");
mysql_connect(localhost,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");
$query="ALTER TABLE gamefilez ADD COLUMN TextColumn VARCHAR(50)";
mysql_query($query);
mysql_close();
echo "New field added";
?>

Anon

At what point does it fail ? You should remove the @ character from the select_db function and verify that you can select the correct DB.

Does your user have the ALTER privilege?

Anon

I am the user. I can add data, update data, delete data from the databse, but the ALTER TABLE statment does not seem to be working. When I run the script, it says that the new field has been added. When I go and check the database nothing has been added.

My scripts are hosted with webfusion, and I get mysql as part of the package. Maybe I do not have the alter privelage.

d-woo

change:
$query="ALTER TABLE gamefilez ADD COLUMN TextColumn VARCHAR(50)";

to:
$query="ALTER TABLE gamefilez ADD TextColumn VARCHAR(50)";

Anon

Thanks for your help. I have tried it, but it is still not adding a new field to the database. Is it possible that the databse is not allowing the ALTER TABLE tag?

Anon

The "alter" works fine on my local database. Try adding some more error checking:

<?
include("dbpasses.inc.php");
mysql_connect(localhost,$username,$password);
mysql_select_db($database) or die( "Unable to select database" . mysql_error() );

$query="ALTER TABLE gamefilez ADD COLUMN TextColumn VARCHAR(50)";

mysql_query($query) or die( "Unable to run query" . mysql_error() );
;
mysql_close();
echo "New field added";
?>

Anon

I have found out what the problem is. I have not been given ALTER privalges on the database by my web hosting company, and should be sorted later today. Thanks for your help.