Anyone see anything wrong here?

dmccabe · December 18, 2008

I have made a very simple form, but for some reason it is not being displayed correctly.

Nothing outputs on the screen after the "Location" selection box. There should be 2 extra input boxes for "Estimated Price" and "Off Fleet Date"

<html>
<head>
</head>
<body>
<?php
include($_SERVER['DOCUMENT_ROOT'] . '/dev/work/remarketing/functions/dbconnect.php');
?>
<form method='POST' action='<?php echo $PHP_SELF; ?>'>

<table>
<tr>
	<td>REG:</td>
	<td><input type="text" name="reg" value="<?php echo $_POST['reg']; ?>"></td>
</tr>
<tr>
	<td>Make:</td>
	<td><SELECT NAME="MAKE_ID"><OPTION value="none">Please Select..</OPTION>
	<?php
		$query = "SELECT * FROM `tbl_veh_make` ORDER BY `NAME` ASC";
		if (!mysql_query($query)) {
			die(mysql_error());
		} else {
			$result = mysql_query($query);
			while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
				echo "<option value='{$row['ID']}' ";
				if (isset($_POST['submit'])) { 
					if ($_POST['MAKE_ID'] == $row['id']) { 
						echo "selected='selected'"; 
					} 
				} 
				echo ">{$row['NAME']}</option>";
			}
		}
	?>
	</SELECT></td>
</tr>
<tr>
	<td>Model:</td>
	<td><SELECT NAME="MODEL_ID"><OPTION value="none">Please Select..</OPTION>
	<?php
		$query = "SELECT * FROM `tbl_veh_model` ORDER BY `NAME` ASC";
		if (!mysql_query($query)) {
			die(mysql_error());
		} else {
			$result = mysql_query($query);
			while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
				echo "<option value='{$row['ID']}' ";
				if (isset($_POST['submit'])) { 
					if ($_POST['MODEL_ID'] == $row['id']) { 
						echo "selected='selected'"; 
					} 
				} 
				echo ">{$row['NAME']}</option>";
			}
		}
	?>
	</SELECT></td>
</tr>
<tr>
	<td>Body Colour:</td>
	<td><SELECT NAME="COLOUR_ID">
	<OPTION value="none">Please Select..</OPTION>
	<?php
		$query = "SELECT * FROM `tbl_veh_colour` ORDER BY `NAME` ASC";
		if (!mysql_query($query)) {
			die(mysql_error());
		} else {
			$result = mysql_query($query);
			while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
				echo "<option value='{$row['ID']}' ";
				if (isset($_POST['submit'])) { 
					if ($_POST['COLOUR_ID'] == $row['id']) { 
						echo "selected='selected'"; 
					} 
				} 
				echo ">{$row['NAME']}</option>";
			}
		}
	?>
	</SELECT></td>
</tr>
<tr>
	<td>Fuel Type:</td>
	<td><SELECT NAME="FUELTYPE_ID"><OPTION value="none">Please Select..</OPTION>
	<?php
		$query = "SELECT * FROM `tbl_fueltype` ORDER BY `NAME` ASC";
		if (!mysql_query($query)) {
			die(mysql_error());
		} else {
			$result = mysql_query($query);
			while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
				echo "<option value='{$row['ID']}' ";
				if (isset($_POST['submit'])) { 
					if ($_POST['FUELTYPE_ID'] == $row['id']) { 
						echo "selected='selected'"; 
					} 
				} 
				echo ">{$row['NAME']}</option>";
			}
		}
	?>
	</SELECT></td>
</tr>
<tr>
	<td>Transmission Type:</td>
	<td><SELECT NAME="TRANSMISSIONTYPE_ID"><OPTION value="none">Please Select..</OPTION>
	<?php
		$query = "SELECT * FROM `tbl_transmission` ORDER BY `NAME` ASC";
		if (!mysql_query($query)) {
			die(mysql_error());
		} else {
			$result = mysql_query($query);
			while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
				echo "<option value='{$row['ID']}' ";
				if (isset($_POST['submit'])) { 
					if ($_POST['TRANSMISSIONTYPE_ID'] == $row['id']) { 
						echo "selected='selected'"; 
					} 
				} 
				echo ">{$row['NAME']}</option>";
			}
		}
	?>
	</SELECT></td>
</tr>
<tr>
	<td>Mileage:</td>
	<td><input type="text" name="mileage" value="<?php echo $_POST['mileage']; ?>"></td>
</tr>
<tr>
	<td>Location:</td>
	<td><SELECT NAME="LOCATION_ID"><OPTION value="none">Please Select..</OPTION>
	<?php
		$query = "SELECT * FROM `tbl_veh_locations` ORDER BY `NAME` ASC";
		if (!mysql_query($query)) {
			die(mysql_error());
		} else {
			$result = mysql_query($query);
			while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
				echo "<option value='{$row['ID']}' ";
				if (isset($_POST['submit'])) { 
					if ($_POST['LOCATION_ID'] == $row['id']) { 
						echo "selected='selected'"; 
					} 
				} 
				echo ">{$row['NAME']}</option>";
			}
		}
	?>
	</SELECT></td>
</tr>
<tr>
	<td>Estimated Price:</td>
	<td><input type="text" name="est_price" value="<?php echo $_POST['est_price']; ?>"></td>
</tr>
<tr>
	<td>Off Fleet Date (DD/MM/YY)</td>
	<td><input type="text" name="off_fleet_date" value="<?php echo $_POST['off_fleet_date']; ?>"></td>
</tr>


</table>
</form>




</body>
</html>

Mark Baker · December 18, 2008

Is there any odd looking data in the Location select box? (Use view source to check both the option values and displayed text)

Sign In

Anyone see anything wrong here?

Recommended Posts

dmccabe

Link to comment

Share on other sites

Mark Baker

Link to comment

Share on other sites

Archived

Browse

Activity

Important Information