mysql question

[Chris]

THis script I am trying to install says this

" Step 1. Run the following SQL-query

ALTER TABLE `subscription` ADD `reoccur` VARCHAR( 10 ) DEFAULT '0' NOT NULL ; "

How the fuck do I do that ? lol

[Jace]

do you already have a table called subscription? if so just paste that into phpmyadmin in the sql section and it should do the work for you

[Chris]

uighhh cant find phpmyadmin in the cpanel

this is a headache
trying tomake this forum subscription based and no fucking sites help

[SilverTab]

uighhh cant find phpmyadmin in the cpanel

this is a headache
trying tomake this forum subscription based and no fucking sites help

click on the DB in CPanel and there will be a link to phpmyadmin....then you click on the DB where your forum is installed, and then on the "SQL" tab...there's a text field where you can paste the query

[SilverTab]

if you can't do it, hit me up on ICQ I can do it for you...it'll take a second...

[prodiac]

THis script I am trying to install says this

" Step 1. Run the following SQL-query

ALTER TABLE `subscription` ADD `reoccur` VARCHAR( 10 ) DEFAULT '0' NOT NULL ; "

How the fuck do I do that ? lol

Yo, hit me up on icq, I'll help you, and walk you through doing it by hand.

3150501

[Hell Puppy]

No offense but you're in over your head if you dont have phpmyadmin on the server and you dont know how to run a sql statement.

You need something that will let you run SQL against the database in question. And it sounds like you may not even know the database name?

Ask your host if you have phpmyadmin installed on your server. If so, login to it, select the database you're trying to update and just paste the statement into the "SQL" tab.

Without phpmyadmin, you're likely looking at having to do it from a unix shell. In which case I'd recommend paying someone to do it for you.

[TheSaint]

Its not much harder from the shell.
Just type "mysql"
Then type use <database name>
Then paste your query, and an extra "ENTER"

But, as said, if you don't really understand what you are doing better to seek help.