search my products database

[SeenGee]

I'm trying to build a simple search facility for a products list on my site. I was given a function by someone but i'm not altogether sure what i need to do with it.

this is what i've got for search.php:

<?php
include 'db.php';
require 'functions.php';

pagetop(Searcher, $accepted, $username);

function searchActiveProducts($field, $searchstr, $from = 0, $to = 9999) {
$products = array();
$sql = "SELECT * from products where $field LIKE '%$searchstr%' limit $from, $to";
$result = @mysql_query($sql);
if ( $result == false )
{
/* echo @mysql_error(); */
}
else 
{
$result = @mysql_query( $sql );
if ( $result != false ) {
while(($record = @mysql_fetch_assoc($result))) {
array_push ($products, $record); 
}
}
}
@mysql_free_result($result);
@mysql_close($dbconn);
return $products;
}
?>

<FORM NAME='search' METHOD='GET' ACTION='searchresults.php?page=1'>
Search our Catalog:<BR>
<SELECT NAME='searchby'>
<OPTION VALUE='printer'>Printer
<OPTION VALUE='brand'>Brand
</SELECT>
<INPUT TYPE='TEXT' NAME='searchstr' SIZE='20' MAXLENGTH='30' VALUE=''>
<INPUT TYPE='submit' VALUE='Go'>

</FORM>

<?
pagebottom();
?>

This is passing info to searchresults.php like this:

searchresults.php?searchby=brand&searchstr=epson

Not too sure what i need to be doing within this page to display the results, presuming the function is called from functions.php, do i just need to call the function, and whats the deal with array_push?

any help would be much appreciated.

[SeenGee]

right, i've kinda changed track here a bit, i've got it working like this

How can i adjust this code so that i am able to search for any term that is inside the database, it could be a brand name, printer name, product code ... anything.?

searchresults.php:

<?php
require 'functions.php';
include 'db.php';

pagetop(Searcher, $accepted, $username);

$field = $_GET['searchby'];
$searchstr = $_GET['searchstr'];

$sql = "SELECT * from products where $field LIKE '%$searchstr%'";
//echo $sql;
$result = @mysql_query($sql);
$numResults = @mysql_num_rows($result);

if($numResults >0)
{
echo '<table>';
	while ($row = mysql_fetch_object($result))
						{

						$brand=$row->brand;
						$printer=$row->printer;
						$code=$row->code;

						echo '
						<tr>
							<td>
								'.$brand.'
							</td>
							<td>
								'.$code.'
							</td>
							<td>
								'.$printer.'
							</td>
						</tr>';



													}
	echo '</table>';
}

else
{
	echo 'no results';
}



pagebottom();


?>

search.php:

<FORM NAME='search' METHOD='GET' ACTION='searchresults.php'>
Search our Catalog:<BR>
<SELECT NAME='searchby'>
<OPTION VALUE='printer'>Printer
<OPTION VALUE='brand'>Brand
<OPTION VALUE='keyword'>Keyword
</SELECT>
<INPUT TYPE='TEXT' NAME='searchstr' SIZE='20' MAXLENGTH='30' VALUE=''>
<INPUT TYPE='submit' VALUE='Go'>

</FORM>

Thanks a lot.