Ok i tried to just make the page as simple as possible but i still get no display when i hit the submit button.
If someone can tell me what i am doing wrong then dont hesitate to enlighten me.<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
<html>
<head>
<title>DBTest</title>
</head>
<body>
<?php
$lowmpg = $GET['lowest_mpg];
$highmpg = $GET['highest_mpg'];
$all= $GET['all'];
$lowprice = $GET['lowest_price'];
$highprice = $_GET['highest_price'];
$con = @mysql_connect("localhost", "webuser", "webaccess");
if (!$con) { die('Cound not connect: ' . mysql_error()); }
mysql_select_db("Cars", $con);
$Result = mysql_query("SELECT FROM Inventory");
if ($all == "true")
{
$Result = mysql_query("SELECT FROM Cars_Inventory");
echo "<p>$Result</p>";
}
if ($lowmpg == "true")
{
$Result = mysql_query("SELECT MIN(MPG) FROM Cars_Inventory");
echo "<p>$Result</p>";
}
if ($highmpg == "true")
{
$Result = mysql_query("SELECT MAX(MPG) FROM Cars_Inventory");
echo "<p>$Result</p>";
}
if ($lowprice == "true")
{
$Result = mysql_query("SELECT MIN(Price) FROM Cars_Inventory");
echo "<p>$Result</p>";
}
if ($highprice == "true")
{
$Result = mysql_query("SELECT MAX(Price) FROM Cars_Inventory");
echo "<p>$Result</p>";
}
mysql_close($con);
?>
</body>
</html>
