[RESOLVED] Intelligent Search

[gitosh]

Hi guys,
I'm developing a search engine to retrieve data from the DB based on the search value entered by the user. I have a table that has among other columns, FirstName,SecondName, LastName. Now I'm able to search by name if the user enters a single name but I need to be able to search when the user enters more than one name because that gives more accurate data. I have some code for doing that but the execution takes so long that it gives the following error

"Fatal error: Maximum execution time of 60 seconds exceeded"

here is my code

$whitespace = array("\t", "\n", "\f", "\r", "+", "!", '"', "£", "$", "€", "%", "^", "&", "*", "(", ")", "-", "_", "+", "=", "{", "[", "}", "]", ";", ":", "@", "'", "#", "~", "<", ">", ",", ">", ".", "/", "?", "|", "\\", "¬", "`", "¦");

if (isset($_POST['vselect'])) 
{

  if($_POST['vselect']=="Customer Name")
    {
	 $x=$_POST['svalue'];
	 $searchV=str_replace($whitespace," ",$x);
	 $searchV2=explode(" ",$searchV);
	 $no=count($searchV2);
	 $count=0;
	  echo $searchV2[$count];

           while ($count < 2);
  {

 echo $count;
 echo $searchV2[0];
 $sqlquery=mssql_init("Gssp_GetPrivCustomerDetailsGivenName",$sqlconnect);
 mssql_bind($sqlquery,"@CustName",&$searchV2[0],SQLVARCHAR);
 $count++;
 }

The error comes on the while loop line and Gssp_GetPrivCustomerDetailsGivenName is a stored procedure.
Where I'm I going wrong on this one?

[timus]

Hey

I think you'll need to add unset($sqlquery) within your loop for one thing although i''ve never used mssql but thats suggested on the php manual

Have you tried taking the mssql_init() out of the loop? and seeing if that causes the timeout?

Also do you need $result = mssql_execute(); to execute the procedure?

Also you dont need the ; at the end of the while () line do you?

If you call your stored procedure with the parameters without the loop and it still times out, then that would suggest its not your PHP code, more the procedure

Hope this helps
Tim

[gitosh]

Hi timus,
I don't know why I put that semi colon on the while,damn me! anyway it's the one that was causing the time out. Thanks