rendered paste body<?php// Author: Murdoc// Date: Sept 2 2007// Time Started: 10:48PM// Last Modified: Sept 05 2007 [3:12pm]// TB search Engineclass search{var $search_string_global;var $result;var $counter; function do_search($query) { if (empty($query)) { header ("location: index.php"); } myconnect(); $search_string = mysql_escape_string($query); $mysqlquery=mysql_query("SELECT * FROM `data` WHERE number LIKE '%".$search_string."%' or callType LIKE '%".$search_string."%' or lineType LIKE '%".$search_string."%' or TMname LIKE '%".$search_string."%'")or die (mysql_error()); if (mysql_num_rows($mysqlquery)==0) { $info = "no result"; $this -> counter = mysql_num_rows($mysqlquery); } else { $this -> counter = mysql_num_rows($mysqlquery); while ($end_result=mysql_fetch_array ($mysqlquery)) { $info[] = $end_result; } } $this->result=$info; } function search_return() { $result = $this->result; $number_of_item=count ($result); $i=0; while ($i < $number_of_item) { $add_date= $result[$i]['addDate']; $TMname=$result[$i]['TMname']; $number=$result[$i]['number']; $call_type=$result[$i]['callType']; $line_type=$result[$i]['lineType']; $locaton=$result[$i]['location']; $count=$result[$i]['count']; $id=$result[$i]['id']; echo "<tr id=\"returned_result\"><td>$add_date</td><td>$TMname</td><td>$number</td><td>$call_type</td><td>$line_type</td><td>$location</td><td>$count</td><td><a class=\"returned_result\" href=\"index.php?a=7&id=$id\">Verify</a></td></tr>"; $i++; } }}?>