hi, im developing a php/mysql web app and i was wondering what the best way to search multiple columns of a table for a particular keyword is. im still pretty new to the whole php/mysql scene, so go easy. if this is a super complex task and someone is willing to give me one, i would love a crash course or at least a hand pointing me in the right direciton. thanks

    I had to write my own.

    Look up "Fulltext search" for info on searching.

    I just broke down and created a small function set for my content script...you pass it field names and keywords, it spits out a where clause that you can use in you SQL call.

    http://www.shrum.net/code/?search=where

    Unless someone else can point you to an easier solution, that's my 2 cents.

      Write a Reply...