";
PRINT "Search";
PRINT "";
$dbname = "example";
$cname = $_POST["cname"];
/* MySQL table created to store the data */
$customer = "customer";
$product = "product";
$transaction = "transaction";
/* make connection to database */
MYSQL_CONNECT() OR DIE("Unable to connect to database server");
@mysql_select_db("$dbname") or die("Unable to select database");
/* Select the data from tables */
$query = "SELECT * FROM $customer, $product, $transaction WHERE $customer.cid = $transaction.cid and $product.pid = $transaction.pid and $customer.cname = '$cname'";
$result = MYSQL_QUERY($query);
/* How many rows in the result? */
$number = MYSQL_NUMROWS($result);
/* Print these results to the screen in a nice format */
$i = 0;
if ($number == 0){
PRINT "No such product(s) in the database!
";
}else if ($number > 0){
PRINT "";
PRINT "Product(s): $number
";
PRINT "";
while ($i < $number){
$pname = mysql_result($result, $i, "pname");
PRINT "";
PRINT "| $pname | ";
PRINT "
";
$i++;
}
PRINT "
";
PRINT "";
}
PRINT "
";
PRINT "Back";
PRINT "";
PRINT "