ALTER TABLE ..Pleas how ?

Hi Everyone.

Befor tow monthes i try to install poll hack and PM hack
and i fail .why ? cos some thing called ALTER TABLE to create a new field in the tabls.

How i can creat a new fields in tabls ? what is the STEPS to do that ?

whin i run this file:

<?php
require("global.php3");
$DB_site->query("ALTER TABLE user ADD buddylist TEXT not null");
echo "done";
?>

this message came:

There seems to have been a slight problem with the database. Please try again by pressing the refresh button in your browser.

An E-Mail has been dispatched to our Technical Staff, who you can also contact if the problem persists.

We apologise for any inconvenience.



And i recive this mail :

mysql error: alter command denied to user: 'onaizah@localhost' for table 'user'
mysql error number: 1142


I know that my host have to do something , but i dont know what he have to , he need my help.

So what can we do to solve this ?



Thank you

[Edited by dellow on 12-09-2000 at 04:36 AM]

You need to talk to your host and tell them to give you alter permissions. (assuming you're on a shared server)