Помощ за 1 урок

EmPowerYou

Registered
Имам проблем с урока за пренареждане на навигационното меню. Пренареждам си менюто както си искам и като изпратя формата то си е пак както преди, не се променя.

red.php
Код:
<HTML>
<HEAD>

<script type="text/javascript">
function move(fbox, tbox) {
     var arrFbox = new Array();
     var arrTbox = new Array();
     var arrLookup = new Array();
     var i;
     for(i=0; i<tbox.options.length; i++) {
          arrLookup[tbox.options[i].text] = tbox.options[i].value;
          arrTbox[i] = tbox.options[i].text;
     }
     var fLength = 0;
     var tLength = arrTbox.length
     for(i=0; i<fbox.options.length; i++) {
          arrLookup[fbox.options[i].text] = fbox.options[i].value;
          if(fbox.options[i].selected && fbox.options[i].value != "") {
               arrTbox[tLength] = fbox.options[i].text;
               tLength++;
          } else {
               arrFbox[fLength] = fbox.options[i].text;
               fLength++;
          }
     }
     arrFbox.sort();
     
     fbox.length = 0;
     tbox.length = 0;
     var c;
     for(c=0; c<arrFbox.length; c++) {
          var no = new Option();
          no.value = arrLookup[arrFbox[c]];
          no.text = arrFbox[c];
          fbox[c] = no;
     }
     for(c=0; c<arrTbox.length; c++) {
     	var no = new Option();
     	no.value = arrLookup[arrTbox[c]];
     	no.text = arrTbox[c];
     	tbox[c] = no;
     }
}

function selectAll(box) {
     for(var i=0; i<box.length; i++) {
     box[i].selected = true;
     }
}
</script>


</HEAD>
<BODY>


<form method="POST" name="combo_box" ACTION="prered.php">
<table cellpadding="4" cellspacing="0" border="0">
<tr>
<td>
<select multiple size="10" name="list1[]" id="list1" style="width:150" onDblClick="move(document.combo_box.list1,document.combo_box.list2)">

<?
$user="***";
$password="***";
$database="***";
mysql_connect("db4.awardspace.com",$user,$password);
@mysql_select_db($database) or die( "Unable to select database");
$chars="SET CHARACTER SET cp1251";mysql_query($chars);

$query="SELECT * FROM sydyrzhanie order by red ";
$result=mysql_query($query)
or die ("Zaqwkata ne mozhe da se izpylni!");
$broi=mysql_num_rows($result);

while ($row = mysql_fetch_array($result))
{
$id=$row["id"];
$name=$row["name"];
echo "<option value='$id'>$name</option>";
}

mysql_close();
?>
</select>
</td>
<td align="center" valign="middle">
<input type="button" onClick="move(this.form.list2,this.form.list1)" value="<<" id=button1 name=button1>
<input type="button" onClick="move(this.form.list1,this.form.list2)" value=">>" id=button2 name=button2>
</td>
<td>
<select multiple size="10" name="list2[]" id="list2" style="width:150" onDblClick="move(document.combo_box.list2,document.combo_box.list1)">
</select>
</td>
</tr>
<tr><td align="center" colspan="3">
<input type="submit" name="submit_button" value="Submit" onClick="selectAll(document.combo_box.list2);">
</td></tr>
</table>
</form>


</BODY>
</HTML>

prered.php
Код:
<HTML>
<HEAD>
</HEAD>
<BODY>

<?
$list2[]=$HTTP_POST_VARS['list2[]'];

$kolko=count($list2);

$user="***";
$password="***";
$database="***";
mysql_connect("db4.awardspace.com",$user,$password);
@mysql_select_db($database) or die( "Unable to select database");
$chars="SET CHARACTER SET cp1251";mysql_query($chars);

for($red=0; $red<($kolko-1); $red++){
$id=$list2[$red];

$query = "Update sydyrzhanie SET red='$red' Where id='$id'";
$result=mysql_query($query)
or die ("Zaqvkta ne mozhe da se izpylni!");
}

echo "<BR><BR><B>Връзките в менюто бяха пренаредени успешно!</B>";

mysql_close();

?>

<BR><B><A href="red.php">Ново пренареждане/ Виж резултата</A></B>

</BODY>
</HTML>

Защо не става не знам, на демото урока си работи...
 
Нещо не се получава, значи ето моя код:
addnav.php (red.php), а javascript-а е същия както по-горния
Код:
<script type="text/javascript" src="css/navsort.js"></script>
<form method="POST" name="combo_box" ACTION="pro.php?page=navsort">
<table cellpadding="4" cellspacing="0" border="0">
<tr>
<td>
<select multiple size="10" name="list1[]" id="list1" style="width:150" onDblClick="move(document.combo_box.list1,document.combo_box.list2)">

<?php
$query = "SELECT * FROM nav ORDER BY red";
$result = @mysql_query($query);
$broi = mysql_num_rows($result);

while ($row = mysql_fetch_array($result))
{
$id=$row["id"];
$name=$row["name"];
echo "<option value='$id'>$name</option>";
}
?>

</select>
</td>
<td align="center" valign="middle">
<input type="button" onClick="move(this.form.list2,this.form.list1)" value="<<" id="button1" name="button1">
<input type="button" onClick="move(this.form.list1,this.form.list2)" value=">>" id="button2" name="button2">
</td>
<td>
<select multiple size="10" name="list2[]" id="list2" style="width:150" onDblClick="move(document.combo_box.list2,document.combo_box.list1)">
</select>
</td>
</tr>
<tr><td align="center" colspan="3">
<input type="submit" name="submit_button" value="Submit" onClick="selectAll(document.combo_box.list2);">
</td></tr>
</table>
</form>

navsort.php (prered.php)
Код:
<?php
$list2[]=$_POST['list2[]'];
$red = $_GET['red'];
$kolko=count($list2);

for($red=0; $red<($kolko-1); $red++){
$id=$list2[$red];

$query="UPDATE nav SET red='$red' WHERE id='$id'";
$result=mysql_query($query)
or die ("Zaqvkta ne mozhe da se izpylni!");
}

echo "<BR><BR><B>Връзките в менюто бяха пренаредени успешно!</B>";

?>

<BR><B><A href="red.php">Ново пренареждане/ Виж резултата</A></B>

Ако пък не става да се оправи дайте някакъв друг код, който да пренарежда менюто.
 

Back
Горе