[RESOLVED] changing the order of the text in multiselect

[thread_PHP]

Hello All
I need help i am changing the order in the multiple select box using following code

<?php
session_start();
require("getconnect.php");
if($_GET['action'] == 'test')
{
	$a= $_POST['order'];
	$b='';

for($i=0;$i<=(sizeof($a)-1);$i++)
{

	if($i==(sizeof($a)-1))
		{
			$b.=$a[$i];
		}
	else
	{			$b.=$a[$i].","; 
	}

}

	$c=explode(",",$b);


$d=sizeof($c);


for($i=0;$i<=$d;$i++)
{
	$selqry="select fileid,content from cms where filename='".$c[$i]."'";


	$res=mysql_query($selqry,$concsn);

	$row=mysql_fetch_row($res);

		$fileid=$row[0];
		$filecontent=$row[1];

		if($i==$d-1)
		{
			$fileidarr.=$fileid;
			$filecontentarr.=$filecontent;
		}
		else
		{
			$fileidarr.=$fileid.",";

		}
}

$c1=explode(",",$fileidarr);

$selqry="delete from tempcms";

$example=mysql_query($selqry);

for($i=0;$i<=$d-1;$i++)
{

	$selqry="insert into tempcms(tempfileid,tempfilename,tempcontent)values(".$i.",'".$c[$i]."','".$filecontent."')";

$res=mysql_query($selqry,$concsn);

}
}

?>

<form name="form1" method="post" action="addnewpage.php?action=test" onSubmit="selectall('order');">
<table border="0" cellpadding="0" cellspacing="0"><tr>
<td colspan="4">
<select name="order[]" size="16" multiple="multiple" id="order"  ondblclick="selectnone(this);">

<?php


 $qry="select tempfilename from tempcms order by tempfileid ";

 $res=mysql_query($qry,$concsn);
 while($row=mysql_fetch_array($res,MYSQL_BOTH))
 { 
 		$filename=$row['tempfilename'];
	$id=$row['tempfileid'];
	$content=$row['tempcontent'];

?>
<option value="<?php echo $filename; ?>"><?php echo $filename;?></option><?php } ?>
</select>

<input type="submit" name="submit" value="Store this structure"   />



&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<input type="button" value="  Up   " onClick="up('order');" title="Up" style="padding: 0; margin: 0; height: 22px;" /></td>
  </tr>
  <tr>
   <td colspan="4" align="right">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<input type="button" value="Down" onClick="down('order');" title="Down" style="padding: 0; margin: 0; height: 22px;" /></td>
  </tr>
  <tr>
  <td>
  <input type="button" name="Backtoindex" value="Back To Index" onclick="javascript:window.location.href('index.php');" />&nbsp;&nbsp;&nbsp;&nbsp;</td>
  <td><a href="frontend.php" target="_blank" class="Style1">Frontend</a>&nbsp;</td>
  <td>&nbsp;&nbsp;<a href="update.php" name="test" class="Style1">Update</a>&nbsp;&nbsp;&nbsp;</td>
  <td align="right"><input type="button" value="Remove" onClick="removeitem('order',true);" title="Remove" style="padding: 0; margin: 0; height: 22px;" /></td>
  </tr>
</table>

</form>

<?php
session_start();
require("getconnect.php");
if($_GET['action'] == 'test')
{
	$a= $_POST['order'];
	$b='';

for($i=0;$i<=(sizeof($a)-1);$i++)
{

	if($i==(sizeof($a)-1))
		{
			$b.=$a[$i];
		}
	else
	{			$b.=$a[$i].","; 
	}

}

	$c=explode(",",$b);


$d=sizeof($c);


for($i=0;$i<=$d;$i++)
{
	$selqry="select fileid,content from cms where filename='".$c[$i]."'";


	$res=mysql_query($selqry,$concsn);

	$row=mysql_fetch_row($res);

		$fileid=$row[0];
		$filecontent=$row[1];

		if($i==$d-1)
		{
			$fileidarr.=$fileid;
			$filecontentarr.=$filecontent;
		}
		else
		{
			$fileidarr.=$fileid.",";

		}
}

$c1=explode(",",$fileidarr);

$selqry="delete from tempcms";

$example=mysql_query($selqry);

for($i=0;$i<=$d-1;$i++)
{

	$selqry="insert into tempcms(tempfileid,tempfilename,tempcontent)values(".$i.",'".$c[$i]."','".$filecontent."')";

$res=mysql_query($selqry,$concsn);

}
}

?>

when i am updating the structure in the multiple select box in this page i am loosing the content in the data

please help me

[thread_PHP]

I HAVE CHANGED MY INDEX.PHP IN THE FOLLOWING WAY AND MY CODE IS WORKING

<?php
session_start();
include 'getconnect.php';

include("FCKeditor/fckeditor.php") ;
?>
<?php
if(isset($_GET['action'])== 'update')
	{

	$a=$_POST['FCKeditor1'];

	$b=strlen($a);

	if($b==13 || $b ==0)
	{	


		header("Location: index.php?fileid=".$_GET['id']);
		exit();
	}
	$value=addslashes($_POST['FCKeditor1']);
	$data=htmlspecialchars($value);

$qry="select tempfilename from tempcms where tempfileid=".$_GET['fileid'];

$res=mysql_query($qry,$concsn);

$row=mysql_fetch_row($res);
$filename=$row[0];
//echo $filename;

	$queryUpdatetempcms = "update tempcms set ";
	$queryUpdatetempcms .="tempcontent = '".$data."'";
	$queryUpdatetempcms .= " where tempfileid =".$_GET['fileid'];

//echo $queryUpdatetempcms;


	$result=mysql_query($queryUpdatetempcms);

	$queryUpdatetemp1cms = "update cms set ";
	$queryUpdatetemp1cms .="content = '".$data."'";
	$queryUpdatetemp1cms .= " where filename='".$filename."'";

#echo $queryUpdatetemp1cms;

	$result123=mysql_query($queryUpdatetemp1cms);


	if(!$result && $result123)
		{

			$_SESSION['message'] = mysql_error();
			header("Location:index.php");
			exit();
		}
	else
	{

		$_SESSION['message']="Record Updated Successfully";
		header("Location:index.php");
		exit();		
	}	



}


?>
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>CMS </title>
<link href="style.css" rel="stylesheet" type="text/css" />

<style type="text/css">
<!--
.style1 {font-size: 12px}
.style6 {color: #FF0000}
-->
</style>
</head>

<body>
<?php
if(isset($_GET['module']) && ($_GET['module'] =='get')) {?>
<form name="news" method="post" action="index.php?action=update&fileid=<?php echo $_GET['id'];?>" >
<?php } else if(!isset($_GET['module']) || ($_GET['module']=='')){ ?>
<form name="news" method="post" action="FCKeditor/_samples/php/sampleposteddata.php">
<?php } ?>
  <table width="100%" border="0" cellspacing="0" cellpadding="0">
    <tr>
      <td  align="left" valign="top">&nbsp;</td>
    </tr>
    <tr>
      <td align="left" valign="top" class="toptablebackbround"></td>
    </tr>
    <tr>
      <td align="left" valign="top" class="tablebackgroundwhite">

  <table width="100%" border="0" cellspacing="0" cellpadding="0">
    <tr>
      <td width="240" align="center" valign="top">
	  <?php 
	  		  include("left.php"); ?></td>
      <td align="left" valign="top">
<table>
		<tr>
			<td><font color="#FF0000">
		  		<?php if(isset($_GET['module']) && $_GET['module']=='insert'){echo "New Record Added&nbsp;Succesfully";}?>
				<?php if(!empty($_SESSION['message'])) echo $_SESSION['message']; $_SESSION['message'] = ''; ?></font>
			</td>

	 </tr>
	 <tr>
	 <td><?php 

	 if(isset($_GET['module']) && $_GET['module']=='get') {


	  $getqry="select * from tempcms where tempfileid=".$_GET['id'];

		$res=mysql_query($getqry);
		$row=mysql_fetch_row($res);
		$name=$row[1];
		$editor=$row[2];

		$getqry1="select * from cms where filename='".$name."'";
		#echo $getqry1;
//			die;
			$resgetqry1=mysql_query($getqry1);
			$rowgetqry=mysql_fetch_row($resgetqry1);

	#	echo $rowgetqry[0];
		#echo $rowgetqry[1];
		$returncontent2=$rowgetqry[2];

		$returncontent3=stripslashes($returncontent2);
		$content12=strtr($returncontent3, array_flip(get_html_translation_table(HTML_SPECIALCHARS)));
		$print12=$content12;


		$returncontent=stripslashes($editor);


	$content1=strtr($returncontent, array_flip(get_html_translation_table(HTML_SPECIALCHARS)));
	$print=$content1;

	 }
	 ?>
</table>

	  <table cellSpacing=0 cellPadding=0 width="100%" border=0>
	 <tr>
     <td align="left"  colspan="8"  class="InputText">&nbsp;&nbsp;<STRONG><?php echo $row[1]; ?></STRONG></td>

					   </tr>

                       <tr>
                         <td colspan="5" >
							<?php
	$oFCKeditor = new FCKeditor('FCKeditor1') ;
	$oFCKeditor->BasePath = 'FCKeditor/';

	if(isset($_GET['module'])== 'get')
	{
//			$oFCKeditor->Value =$print;
			$oFCKeditor->Value =$print12;
		}
		else
		{
			$oFCKeditor->Value ='';

	}
		$oFCKeditor->Create(); 
		?>  </td>
                       </tr>
                       <tr><td colspan="7">&nbsp;</td></tr>

                        <tr>
                           <td colspan="5" align="center">
                        <?php if(isset($_GET['module'])== 'get')
						{   
						?>
							<input type="submit" name="Update" value="Update">
						<?php
						}
						else{
						?>	
                      <input name="Submit" type="submit"  value="Submit">
                         <?php
						 }
						 ?>   

                          </td>


                          </tr>

                        </table></td>
      <td width="20" align="left" valign="top">&nbsp;</td>
    </tr>
  </table>
  </td>
</tr>
<tr>
  <td align="left" valign="top" colspan=6 class="bottomtablebackbround"></td>
</tr>
<tr>
  <td height="25" align="left" valign="bottom"><a href="addnewpage.php">Add New Page</a></td>
</tr>
<tr>
  <td align="left" valign="top">&nbsp;</td>
</tr>
  </table>
</form>
</body>
</html>