[Phpbb-checkins] CVS: phpBB2/includes search.php,1.8,1.9

[Paul S. O. <ps...@us...>]

Update of /cvsroot/phpbb/phpBB2/includes
In directory usw-pr-cvs1:/tmp/cvs-serv32164/includes

Modified Files:
	search.php 
Log Message:
Should fix error with DB != MSSQL || MySQL bug #517151

Index: search.php
===================================================================
RCS file: /cvsroot/phpbb/phpBB2/includes/search.php,v
retrieving revision 1.8
retrieving revision 1.9
diff -C2 -r1.8 -r1.9
*** search.php	12 Feb 2002 00:04:55 -0000	1.8
--- search.php	14 Feb 2002 17:43:56 -0000	1.9
***************
*** 116,125 ****
  
  	$word = array();
- 	$word_text_sql = array();
  	while( list($word_in, $search_matches) = @each($search_raw_words) )
  	{
  		if( !empty($search_matches) )
  		{
- 			$word_text_sql[$word_in] = "";
  			for ($i = 0; $i < count($search_matches); $i++)
  			{ 
--- 116,123 ----
***************
*** 129,133 ****
  				{
  					$word[] = $search_matches[$i]; 
- 					$word_text_sql[$word_in] .= ( ( $word_text_sql[$word_in] != "" ) ? ", " : "" ) . "'" . $search_matches[$i] . "'";
  				} 
  			}
--- 127,130 ----
***************
*** 140,143 ****
--- 137,141 ----
  
  		$prev_word = "";
+ 		$word_text_sql = "";
  		$temp_word = array();
  		for($i = 0; $i < count($word); $i++)
***************
*** 146,149 ****
--- 144,148 ----
  			{
  				$temp_word[] = $word[$i];
+ 				$word_text_sql .= ( ( $word_text_sql != "" ) ? ", " : "" ) . "'" . $word[$i] . "'";
  			}
  			$prev_word = $word[$i];