Click here to Skip to main content
15,920,503 members
Home / Discussions / Web Development
   

Web Development

 
AnswerRe: Dynamic DIV Pin
Guffa18-Apr-06 2:09
Guffa18-Apr-06 2:09 
AnswerRe: Dynamic DIV Pin
Guffa18-Apr-06 2:14
Guffa18-Apr-06 2:14 
GeneralRe: Dynamic DIV Pin
CoolASL18-Apr-06 3:36
CoolASL18-Apr-06 3:36 
AnswerRe: Dynamic DIV Pin
Guffa18-Apr-06 6:41
Guffa18-Apr-06 6:41 
GeneralRe: Dynamic DIV Pin
CoolASL18-Apr-06 21:19
CoolASL18-Apr-06 21:19 
GeneralRe: Dynamic DIV [modified] Pin
Shog918-Apr-06 17:05
sitebuilderShog918-Apr-06 17:05 
GeneralRe: Dynamic DIV [modified] Pin
CoolASL18-Apr-06 21:18
CoolASL18-Apr-06 21:18 
QuestionMySql Regexp Pin
rgoyal18-Apr-06 1:50
rgoyal18-Apr-06 1:50 
Following is the requirement for search component:

Input:

Only 1 search box in which I will put 1 or more words(separated by space)

Output:

I need to search space separated parts of this string in multiple fields of multiple tables.

What I have done?
$keywordList = explode( ' ', trim($_REQUEST['txtSearch']) );

$i = 0;

while($i < count($keywordList)){

        $strKeyword.= "
        r.userId like '%$keywordList[$i]%'
	or r.maritalStatus like '%$keywordList[$i]%'
	or r.nativeLang like '%$keywordList[$i]%'
	or ro.personalStatement like '%$keywordList[$i]%'
	or ro.empReq like '%$keywordList[$i]%'
	or ro.hobbies like '%$keywordList[$i]%'
	";

	$i++;

	if($i < count($keywordList)){
		$strKeyword.= " or ";
	}

}

This is working according to my requirements
I need to do it in MySql and PHP with regexp.

Any Help?
Thanks
QuestionForm Method Pin
Amol Ravatale17-Apr-06 19:09
Amol Ravatale17-Apr-06 19:09 
GeneralRe: Form Method Pin
Guffa17-Apr-06 20:56
Guffa17-Apr-06 20:56 
AnswerRe: Form Method Pin
NeverHeardOfMe18-Apr-06 1:51
NeverHeardOfMe18-Apr-06 1:51 
GeneralRe: Form Method Pin
alexey N18-Apr-06 2:02
alexey N18-Apr-06 2:02 
AnswerRe: Form Method Pin
Guffa18-Apr-06 2:16
Guffa18-Apr-06 2:16 
QuestionGenerate xml files Pin
prasenc17-Apr-06 18:31
prasenc17-Apr-06 18:31 
AnswerRe: Generate xml files Pin
alexey N17-Apr-06 18:41
alexey N17-Apr-06 18:41 
GeneralRe: Generate xml files Pin
prasenc18-Apr-06 22:55
prasenc18-Apr-06 22:55 
QuestionMaking HTML page printable Pin
jmfekete17-Apr-06 8:19
jmfekete17-Apr-06 8:19 
AnswerRe: Making HTML page printable Pin
Shog917-Apr-06 9:09
sitebuilderShog917-Apr-06 9:09 
QuestionJapan Charackters and MySQL Pin
progman17-Apr-06 1:42
progman17-Apr-06 1:42 
AnswerRe: Japan Charackters and MySQL Pin
alexey N17-Apr-06 1:54
alexey N17-Apr-06 1:54 
GeneralRe: Japan Charackters and MySQL Pin
progman17-Apr-06 3:22
progman17-Apr-06 3:22 
AnswerRe: Japan Charackters and MySQL Pin
Guffa17-Apr-06 8:30
Guffa17-Apr-06 8:30 
QuestionCOMBO BOX Pin
Harikrk17-Apr-06 1:08
Harikrk17-Apr-06 1:08 
AnswerRe: COMBO BOX Pin
Guffa17-Apr-06 2:12
Guffa17-Apr-06 2:12 
Questionm how to pass the value from one page to another page in asp.net Pin
Chetan.visodiya17-Apr-06 0:16
Chetan.visodiya17-Apr-06 0:16 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.