Helping ordinary people create extraordinary websites!

Go Back   Web Development Forum > Website Programming > Database Development
Register FAQ Members List Calendar Search Today's Posts Mark Forums Read

Reply
 
LinkBack Thread Tools Display Modes
  #1 (permalink)  
Old 01-09-2008, 10:21 AM
Member
 
Join Date: Aug 2005
Posts: 88
Default sql: search multiple keywords for one image

I am doing the search for multiple keywords.
ok, let say user input keywords : one two three to search an image.(exactly words)
in the database, there is an image with the keywords : one, two.
May I know how to query it out for one time only? Even if this image have two match keywords, but it only can display out one time in the search result. can someone please guide me? i do not how to query it out. Please help.thank you.
__________________
md
AskAGeek.com - Where geeks answer your computer and tech questions.
Ann-Lindsey.com - My Wife's Budget Fashion and Shopping Blog
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2 (permalink)  
Old 01-09-2008, 12:08 PM
BigAlReturns's Avatar
Moderator Extraordinaire!
 
Join Date: Dec 2007
Location: The Wirral, England
Posts: 291
Send a message via MSN to BigAlReturns
Default

Could you use the UNIQUE modifier in this instance? E.g.

SELECT UNIQUE image_id,etc FROM table WHERE conditions
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Search Engine Optimization Strategy pntglobal Search Engine Optimization 2 12-10-2007 11:54 AM


All times are GMT -5. The time now is 05:26 AM.


Website Design by Ducani Media Group
Powered by vBulletin® Version 3.6.8
Copyright ©2000 - 2009, Jelsoft Enterprises Ltd.