phpMyAdmin Help needed

[melaniejk]

Hi.
I need help doing one step in a Mod for my php Link Directory.
The guy who was going to help left the php LD forum and i'm stuck in the middle of the process.

Anyone online now that could help?

I just have a few simple questions.


#-----[ SQL ]------------------------------------------
# Where 'PLD_' is your table prefix
ALTER TABLE `PLD_LINK` ADD `DISPLAYURL` VARCHAR( 255 ) NOT NULL ;
INSERT INTO `PLD_CONFIG` (`ID`, `VALUE`) VALUES ('ENABLE_DISPLAYURL', '1');






There is this white box that pops up for
Server: localhost Database: genealog_geekdir Table: PLD_LINK

I think I'm supposed to type the stuff from the first part upabove into that box. But, it already has the following text in it.
Do I delete it or put my stuff underneath it? Then, do I click on Insert ?

SELECT * FROM `PLD_LINK` WHERE 1





Thank you

[T0PS3O]

SELECT * FROM `PLD_LINK` WHERE 1 is the standard query which shows you all in that table.

Delete that and replace it with the query you need to do.

[melaniejk]

Hi.
Thank you for the reply. I'm such a newbie with php and databases.
I'm afraid to play around with the database too much because I don't want to destroy it. :)

Just to clearify....
After I delete that standard query line and then put the following into the box as is:

ALTER TABLE `PLD_LINK` ADD `DISPLAYURL` VARCHAR( 255 ) NOT NULL ;
INSERT INTO `PLD_CONFIG` (`ID`, `VALUE`) VALUES ('ENABLE_DISPLAYURL', '1');

If yes, how do I get it to be added? Do I click on Insert or something?

Sorry, for all the questions.

[melaniejk]

figured it out.
I needed to click on the GO button.