[PHP-DB] HTML Select Boxes not displaying

Nigel Dunn Wed, 30 Oct 2002 19:24:42 -0800

Hi Everyone,

I have encountered a problem with IE that I am unsure how to get around.
I dynamically create quite a few drop down boxes to enable categories to be oredered. It works fine for me (XP box) however everyone else in my office is running ME or 98 and it doesnt work in IE for any of them. Works fine in Netscape and Mozilla. Both myself and my boss are running IE6, same build, however he is ME and I'm XP, and he cant see them either.

Below is the code I'm using....any help with this would be great.

Thanks in advance,
Nigel Dunn

<?
// includes the db connection, etc
include("../config/global.inc");

function display_ordered_list() {

echo "<table width='600' border='0' cellpadding='2' cellspacing='0'>";
echo "<tr><td><b>Category Name</b></td><td align='right'><b>Category Order<b></td></tr>";
$result = mysql_query("SELECT * FROM category WHERE parent_id = '0' ORDER BY list_id, name");
$num_rows = mysql_num_rows($result);
if ($row = mysql_fetch_array($result)) {
do {
$cat_id = $row['id'];
$name = $row['name'];
$list_id = $row['list_id'];
echo "<tr><td>$name</td><td align='right'><select name='cat[$cat_id]'>\n";
echo select_list($list_id, $num_rows);
echo "\n</select></td></tr>\n";

$result2 = mysql_query("SELECT * FROM category WHERE parent_id = '$cat_id' ORDER BY list_id, name");
$num_rows2 = mysql_num_rows($result2);
if ($num_rows2 != 0) {
// echo "<tr><td colspan='2'><hr></td></tr>";
echo "<tr><td> </td><td>\n\n";
echo "<table width='85%' border='0' cellpadding='2' cellspacing='0'>\n";
echo "<tr><td><b>Sub-Category Name</b></td><td align='right'><b>Sub Category Order</b></td></tr>\n";
if ($row2 = mysql_fetch_array($result2)) {
do {
$sub_id = $row2['id'];
$sub_name = $row2['name'];
$sub_list_id = $row2['list_id'];
echo "<tr><td>$sub_name</td><td align='right'><select name='cat[$sub_id]'>\n";
echo select_list($sub_list_id, $num_rows2);
echo "</select></td></tr>\n";
} while ($row2 = mysql_fetch_array($result2));
}
echo "\n</table>\n";
echo "</td></tr>\n";
echo "<tr><td colspan='2'><hr></td></tr>\n";
}
} while ($row = mysql_fetch_array($result));
}
echo "<tr><td colspan='2'><hr></td></tr>\n";
echo "<tr><td> </td><td><input type='submit' name='Submit' value='Submit'></td></tr>\n";
echo "</table>\n";
}

function select_list($id, $total) {

for ($x = 1; $x <= $total; $x++) {
if ($x == $id) {
$option_list .= "<option value='$x' selected>$x</option>\n";
} else {
$option_list .= "<option value='$x'>$x</option>\n";
}
}
return $option_list;
}

?>
<html>
<head>
<title>Order Categories Test</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>

<body>
<form action='<?= $PHP_SELF; ?>' method='POST'>

<?
if ($Submit == "Submit") {

$the_end = false;
$s = reset($cat);
$k = key($cat);
$c = count($cat);

while(!$the_end) {
for($i = 0; $i < $c; $i++) {
$result = mysql_query("UPDATE category SET list_id = '" . $cat[$k] . "' WHERE id = '$k'");
$s = next($cat);
if ($s==false) {
$the_end=true;
} else {
$k = key($cat);
}
}
}
}

display_ordered_list();

?>
</form>
</body>
</html>

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] HTML Select Boxes not displaying

Reply via email to