[RESOLVED] No value returned from dropdown list in IE8

[jenny_baby]

Hi,

I have a drop down list loaded from a mysql database that works fine in Firefox, but does not return the selected value on POST when executed in IE8.

If this a known issue? Is there a work-around?

Code to build the drop down list is as follows:

	<?php
	$dbcon = @mysql_connect('localhost', 'readonly', 'readonly');
	if (!@mysql_select_db('ballymoney')) {

		// Login failed. 

		echo "<script>alert('Login failed!')</script>";
	}

	$result = mysql_query("select crdate from creports order by crdate desc");
	echo "<label>Select Competition Date, then click the GO button : </label>";
	echo "<select \"name=\"compdate\"> id=\"compdate\">\n";

	while ($row = mysql_fetch_assoc($result)) {
		$date = $row['crdate'];
		$year = substr($date, 0, 4);
		$month = substr($date, 5, 2);
		$day = substr($date, 8, 2);

		$dmydate = $day . "/" . $month . "/" . $year;

		echo "<option value=$dmydate>$dmydate</option>\n";
	}

	echo "</select>";
	?>

Code to process selected value is as follows:

	<?php
	if (isset($_POST['compdate'])) {
		$datedmy = $_POST['compdate'];
		$year = substr($datedmy, 6, 4);
		$month = substr($datedmy, 3, 2);
		$day = substr($datedmy, 0, 2);

		$dateymd = $year . "/" . $month . "/" . $day;
		$result = mysql_query("select * from creports where crdate = '" . $dateymd . "'");
	}
	else {
		$result = mysql_query("select * from creports order by crdate desc limit 1");
	}

	$row = mysql_fetch_assoc($result);
	$date = $row['crdate'];
	$year = substr($date, 0, 4);
	$month = substr($date, 5, 2);
	$day = substr($date, 8, 2);

	$dmydate = $day . "/" . $month . "/" . $year;

	echo "<p>Competition Date : " . $dmydate . "</p>";
	echo "<p>Competition Type : " . $row['crdesc'] . "</p>";
	echo "<p>Competition Report : </p>";
	echo "<p>" . $row['crreport'] . "</p>";
	?>

Jennifer

[halojoy]

1. Have a look at View Source in HTML form page
   that the options have really values

2. I suppose you have <form method="post"> ..... </form> tags

3. You have good HTML standard <select opening tag with "quotes" around values/name
   Why dont you use value="something" with quotes around in <option>

4. There is nothing to gain from doing sloopy incorrect HTML code.
   Using valid HTML will reduce chance of some BROWSER will mess you up.

5. I am not sure this will solve your issue.
There is a good possibility there is something else that is not 100% well.
Good Luck 🙂

echo "<select \"name=\"compdate\"> id=\"compdate\">\n";

while ($row = mysql_fetch_assoc($result)) {
$date = $row['crdate'];
$year = substr($date, 0, 4);
$month = substr($date, 5, 2);
$day = substr($date, 8, 2);

$dmydate = $day . "/" . $month . "/" . $year;

echo "<option value=\"$dmydate\">$dmydate</option>\n";
}

echo "</select>";

Edit

---

I see now there are errors in select opening tag

echo "<select \"name=\"compdate\"> id=\"compdate\">\n"; 
//should be
echo "<select name=\"compdate\" id=\"compdate\">\n"; 

[jenny_baby]

Changing the select statement fixed it! Thanks a million, I've been looking at it for hours and never spotted it!

Point taken on HTML coding standards. Thanks.

Jennifer

[bradgrafelman]

A good way to check your HTML is by running it through a good validator.

Also, don't forget to mark this thread resolved (if it is) using the link on the Thread Tools menu.