Web Design Forums

smallbeer · 12-12-2003, 10:20

I'm building a search function but it's for a database I didn't build.

Normally I'd have a seperate table called keywords and each word would have it's own row and be linked to the data in question through a relative id. The database I have to work from doesn't. All the keywords for each row are stored together in the corresponding column called Keywords.

It's Friday and I'm having a hard time getting my head around it. Would I have to do anything different ie seperating the contents of the keywords field into individual words?

Help please.

PHP/MySQL btw.

12-12-2003, 10:20	#1 (permalink)
smallbeer I Ain't Losing Any Sleep™ Join Date: Apr 2003 Posts: 5,236	search function I'm building a search function but it's for a database I didn't build. Normally I'd have a seperate table called keywords and each word would have it's own row and be linked to the data in question through a relative id. The database I have to work from doesn't. All the keywords for each row are stored together in the corresponding column called Keywords. It's Friday and I'm having a hard time getting my head around it. Would I have to do anything different ie seperating the contents of the keywords field into individual words? Help please. PHP/MySQL btw. __________________ That's fuckin' ingenious, if I understand it correctly. It's a Swiss fuckin' watch.

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)