HTTP 404 ERROR
| From: | jeffM at stateind dot com | Date: | Wed, 15 Nov 2000 21:28:58 +0000 |
| Subject: | HTTP 404 ERROR | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-4455@lists.php.net to get a copy of this message | ||
I can't find anything wrong with the script below but every time I try to
run it I get a page not found error HELP!
<html>
<head>
</head>
<form method="post" action="<?php echo $PHP_SELF?>">
<div align="center">
<p> </p>
<p><font size="3"><b><font face="Verdana, Arial,
Helvetica,
sans-serif">From
Year: <select name="fromyear">
<option>1950</option>
<option>1951</option>
<option>1952</option>
<option>1953</option>
<option>1954</option>
<option>1955</option>
</select>
To Year: <select name="toyear">
<option>1956</option>
<option>1957</option>
<option>1958</option>
<option>1959</option>
<option>1960</option>
<option>1961</option>
<option>1962</option>
</select>
Make: <input type="text" name="vehmake">
Model: <input type="text" name="vehmodel">
<input type="submit" value="Search Inventory">
<input type="reset" name="Submit2" value="Clear Form">
</div>
</form>
<p> </p>
</blockquote>
<?php
$db = mysql_connect("LOCALHOST", "USERID", "PASSWORD")
or DIE("Unable to connect to database");
mysql_select_db(DATABASENAME,$db);
if ($fromyear == "")
{$fromyear = '%';}
if ($toyear == "")
{$toyear = '%';}
if ($vehmake == "")
{$vehmake = '%';}
if ($vehmodel == "")
{$vehmodel = '%';}
$result = mysql_query ("SELECT * from VehInventory",$db);
if ($row = mysql_fetch_array ($result)) {
do {
printf("<tr><td>%s %s</td><td>%s</tr>\n",
$myrow["first"],
$myrow["last"],
$myrow["address"]);
print $row["VehYear"], $row["VehMakeLink"],
$row["VehColor"],
$row["VehMileage"],
$row["VehPrice"];
print ("<p>");
} while ($row = mysql_fetch_array($result));
}else {print "Sorry, no records were found ";}
?>
</body>
</html>