• Quickies – September 29, 2006

    0
    scissors
    September 29th, 2006HARTHART

    Ugh! I need help and need an “angel”

    I have a lyrics database, but no script. I do not know PHP and can’t seem to find a script. The tables from the .sql database are:


    — Table structure for table ‘admin’

    CREATE TABLE admin (
    id int(3) NOT NULL auto_increment,
    user varchar(30) NOT NULL default ”,
    pass varchar(40) NOT NULL default ”,
    PRIMARY KEY (id),
    UNIQUE KEY user (user)
    ) TYPE=MyISAM;


    — Table structure for table ‘corrections’

    CREATE TABLE corrections (
    id int(5) NOT NULL default ‘0’,
    title varchar(250) NOT NULL default ”,
    artist varchar(250) NOT NULL default ”,
    album varchar(250) NOT NULL default ”,
    lyrics text NOT NULL,
    comment text NOT NULL
    ) TYPE=MyISAM;

    CREATE TABLE lyrics (
    id int(5) NOT NULL auto_increment,
    title varchar(250) NOT NULL default ”,
    artist varchar(250) NOT NULL default ”,
    album varchar(250) NOT NULL default ”,
    lyrics text NOT NULL,
    PRIMARY KEY (id)
    ) TYPE=MyISAM;

    An entry might look like ..


    INSERT INTO lyrics VALUES (271,'A Day In The Life','Beatles','N/A','I read the news today oh boy
    About a lucky man who made the grade
    And though the news was rather sad
    Well I just had to laugh
    I saw the photograph.

    He blew his mind out in a car
    He didn\'t notice that the lights had changed
    A crowd of people stood and stared
    They\'d seen his face before
    Nobody was really sure if he was from the House of Lords.

    I saw a film today oh boy
    The English Army had just won the war
    A crowd of people turned away
    But I just had a look
    Having read a book I\'d like to turn you on...

    Woke up, fell out of bed,
    Dragged a comb across my head
    Found my way downstairs and drank a cup,
    And looking up I noticed I was late.

    Found my coat and grabbed my hat
    Made the bus in seconds flat
    Found my way upstairs and had a smoke,
    Somebody spoke and I went into a dream

    I read the news today oh boy
    Four thousand holes in Blackburn, Lancashire
    And though the holes were rather small
    They had to count them all
    Now they know how many holes it takes to fill the Albert Hall.
    I\'d love to turn you on.

    ©1967 Lennon & McCartney
    ');

    That was entry 271 .. my database goes up to 167,121 entries..

    I was hoping to implement or embed a search capability (or something) on every post at The-Singers.com .. based on the category – to pull out links of all references to a category (which I use as the artist name) ..

    I have no idea if that’s possible .. or where to find a script .. or a person who can write a script or code…. Ideas? comments? Suggestions? All welcome

    HART

    Related Posts with Thumbnails

Leave a reply