Ok forgot about my original thread on phpsupporttickets I decided to just implement the search script on it;s on page, but anyways I could use some pointers here, I tried this code:
<?
$link = mysql_connect('localhost');
if (!$link) {
die('Not connected : ' . mysql_error());
}
// make foo the current db
$db_selected = mysql_select_db('tickets', $link);
if (!$db_selected) {
die ('Can\'t use : ' . mysql_error());
}
if ($answer == "")
{$answer = '%';}
// $user and $passwd are the two column names I used. Change this to fit your database
$result = mysql_query ("SELECT * FROM tickets_answers
WHERE body LIKE '%$answer%'
");
if ($row = mysql_fetch_array($result)) {
do {
PRINT "<b>Answers: </b> ";
print $row["answer"];
print (" ");
} while($row = mysql_fetch_array($result));
} else {print "Sorry, no records were found!";}
//The end result prints the username / passwd / firstname / lastname / ID / email
//you will have to change these fields also to fit your needs
?>
and when I did a search i got these results:
//search.php Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers: Answers:
any pointers?
