1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

phpMyAdmin Help needed

Discussion in 'Databases' started by melaniejk, Feb 10, 2006.

  1. #1
    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
     
    melaniejk, Feb 10, 2006 IP
  2. T0PS3O

    T0PS3O Feel Good PLC

    Messages:
    13,219
    Likes Received:
    777
    Best Answers:
    0
    Trophy Points:
    0
    #2
    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.
     
    T0PS3O, Feb 11, 2006 IP
  3. melaniejk

    melaniejk Peon

    Messages:
    397
    Likes Received:
    17
    Best Answers:
    0
    Trophy Points:
    0
    #3
    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, Feb 11, 2006 IP
  4. melaniejk

    melaniejk Peon

    Messages:
    397
    Likes Received:
    17
    Best Answers:
    0
    Trophy Points:
    0
    #4
    figured it out.
    I needed to click on the GO button.
     
    melaniejk, Feb 11, 2006 IP