Basic Search Help Please

[timsharpe]

I need a basic search script that would allow me to enter a customer number and search a mysql database for that number, and then display resilts, can anyone please help.

[sijis]

this is my sql for a hacked shopping cart i use.

// $criteria is from a form
// example: <form action="file.php?criteria=order" method="post">
// $OrderNumber is from a field in form

switch($criteria){
	case "order";
		$strSQL = "SELECT * FROM Buyers WHERE OrderNumber = '$OrderNumber' ORDER BY OrderNumber";
	break;
// more stuff...
}
// now lists results
echo "<ul>";
	$result = mysql_query($strSQL,$dbServerConn);
	while($row = mysql_fetch_array($result)) {
		$BBI=$row['BuyerID'];
		$BON=$row['OrderNumber'];
		$BPM=$row['PayMethod'];
		$BCT=$row['CCType'];
		$BCo=$row['Contact'];
		$BNa=$row['Name'];
		echo "<li>$BNa - Order Number <strong>$BON</strong></li>";
		}
echo "</ul>";			

if you don't know the exact orderID you can (i think) alternatively use this sql query:

$strSQL = "SELECT * FROM Buyers WHERE OrderNumber LIKE '%$OrderNumber%' ORDER BY OrderNumber";

this should give you an idea.