View Single Post
  #10 (permalink)  
Old January 11th, 2008, 11:49 AM
kumiko kumiko is offline
Authorized User
 
Join Date: Aug 2006
Location: , , .
Posts: 65
Thanks: 0
Thanked 0 Times in 0 Posts
Default

first, user insert such as --> apple, orange, pear, grape without checked any checkbox, the user will buy default search the input to match with the photo key words.
second, when user check on the Search by photographers name, it will match the string with the photo keywords and also the photographer name ( these two fields are in the same table let say table A).
third, if user check on the checkbox search by lightbox, it will match the input with the lighbox keywords in the table B. table C is store the FK lightbox id & the photo id to show that which photoes are in which lightbox folder.
for the second condition, i dont have idea to continue do the coding. if user checked two cehckbox, the solutionis how? thanx

** http://i263.photobucket.com/albums/i...miko2008/q.jpg