October 7, 2008 01:57pm pdt

03.23.2008 at 03:02PM PDT, ID: 23263057

	[x] Attachment Details

"Modify this search enginge for working as AND and OR state both".

Asked by MOSTAGHASSI in PHP and Databases, MySQL Server

Hi,
I have codes below for a search engine ,it works for OR state ,but i want that if user put and wrap its keywords in this mark(") then the code recognize it and act as AND and without this mark(") it act as OR state.
ThanksStart Free Trial

         
           
             1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
24:
25:
26:
27:
28:
29:

           
           
             if ('option A' == $_REQUEST['select']) {
	$table = 'tbArtist';
	$field = 'ArtistFamilyf';
} else if ('option B' == $_REQUEST['select']) {
	$table = 'tbAlbum';
	$field = 'AlbumName';
} else if ('option C' == $_REQUEST['select']) {
	$table = 'tbtracks';
	$field = 'TrackName';
	
}
$words = split(" ", $_REQUEST['Textfield1']);
$Query = "SELECT * FROM ".$table." WHERE 1=2 ";
 
foreach($words as $word)
{
  if ($word)
  {
    $Query .= " OR $field LIKE '%$word%' ";
  }
}
 
$result = mysql_query($Query);
while ( $rw = mysql_fetch_assoc( $result ) ) {
 
	echo "{$rw["$field"]}<br />\n";
}
 
?>

           
         

Keywords: "Modify this search enginge for worki…

	Title
1	importance of keyword (s) in websi…
2	URGENT - Search for multiple keywords
3	ACT versus Access
4	META keywords...
5	Keyword Search in MS Access with A…
6	ACT Database Moved and is now lock…

Loading Advertisement...

20080716-EE-VQP-32 - Hierarchy / EE_QW_2_20070628

1. hielo 924,332
2. hernst42 445,816
3. angelIII 338,690
4. Ray_Pas... 189,975
5. logudotcom 183,333
6. routinet 169,362
7. Roonaan 135,982
8. RQuadling 131,335
9. glcummins 127,927
10. nplib 105,478
11. yodercm 101,526
12. bportlock 99,462
13. fibo 88,315
14. rowejd 81,043
15. dr_dedo 80,410
16. Xyptilon2 79,792
17. gamebits 55,543
18. ali_kayahan 49,599
19. Michael701 48,100
20. jason1178 47,725
21. jausions 47,640
22. TerryAtO... 47,560
23. steelseth12 47,354
24. Squinky 45,485
25. mankowitz 45,188

1. hernst42 1,001,689
2. hielo 941,257
3. angelIII 923,857
4. ldbkutty 688,003
5. Roonaan 663,922
6. RQuadling 513,948
7. wasifg 506,165
8. snoyes_jw 401,445
9. glcummins 399,240
10. gamebits 311,447
11. steelseth12 304,629
12. i_m_aa... 298,407
13. yodercm 293,762
14. routinet 269,211
15. TeRReF 263,750
16. Diablo84 239,472
17. nizsmo 235,854
18. dr_dedo 214,525
19. akshah123 211,024
20. Raynard7 209,268
21. WoodyRo... 207,207
22. logudotcom 190,301
23. Ray_Pas... 189,975
24. bportlock 176,292
25. nplib 175,702

"Modify this search enginge for working as AND and OR state both".

Asked by MOSTAGHASSI in PHP and Databases, MySQL Server

About this solution