-
Quickies – September 29, 2006
0September 29th, 2006HARTUgh! 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 dreamI 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
These Posts May (or may not) Be Related!