Related Items

triplebig · #1 (**permalink**) 11-29-07, 11:36

this is a newbie questions and sorry for my english

im currently working on a simple lyric page

I have 2 data : title and keyword

when a user view a particular lyric, i want a related lyric by title & keyword to be display

example data in database

title
Green Day Walking Alone

Keywords(separated by commas)
Green Day, walking alone, tabs, midi

i use this code below but the result display only one title which is the same title as the currently viewed lyric

PHP Code:


			
SELECT title, keywords FROM lyrics 

WHERE title LIKE '%".$arr[title]."%'

AND keywords LIKE '%".$arr[keywords]."%'

how to fix this

is my sql format correct ? can i used Between...AND clause

thank u in advance

ortho · #2 (**permalink**) 11-29-07, 11:58

Maybe you can change your AND by a OR ?

you're using php ?

ortho · #3 (**permalink**) 11-29-07, 12:00

You should create a table for your keywords

Something that look like this:
id - song_id - keyword

So your keywords are taken one by one...

I don't see the rest of your code but if your $arr[keywords] looks like this val1,val2,val3 .... you may not be able to search your data as you want

Quote:

this is a newbie questions and sorry for my english

Es-tu francais?

triplebig · #4 (**permalink**) 11-29-07, 12:52

Quote:

Maybe you can change your AND by a OR ?

you're using php ?

i've done that but not working...

yes i'm using php..learn from the net and friends

ok i tested this...i don't know if this format ok to be use

PHP Code:


			
SELECT title, keywords FROM lyrics 
WHERE keywords BETWEEN '".$arr[title]."' AND '".$arr[keywords]."'

it seems working but only in certain page :-( in other page it listed all the unrelated lyrics...strange ? need to test with more title and keyword...

Quote:

You should create a table for your keywords

Something that look like this:
id - song_id - keyword

So your keywords are taken one by one...

i will try to solve this problem first...if nothing works...i will consider this

Quote:

I don't see the rest of your code but if your $arr[keywords] looks like this val1,val2,val3 .... you may not be able to search your data as you want

yes it looks like that
can u tell me why..im a noo-b

Quote:

Es-tu francais?

Non..je suis un malaisien