=============================================

flash actionScript 2.0 내용
------------------------------
System.useCodepage = true;

var dataURL:String = "http://127.0.0.1/~hansoo/";

var iniIdx:Number;

btn.onRelease = function() {
 iniIdx = input_txt.text-1;
 
 var result_lv:LoadVars = new LoadVars();

 result_lv.onLoad = function(success:Boolean) {
  if (success) {
   result_lv.decode(this.n_idx);
   trace(this.toString());
   idx_txt.text = this.n_idx;
   subject_txt.text = this.n_subject;
   name_txt.text = this.n_name;
   contents_txt.text = this.n_contents;
   date_txt.text = this.n_date;
   view_txt.text = this.n_view;
   trace("totalIdx = "+this.totalIdx);
  } else {
   trace("failed to access php data");
  }
 };

 var send_lv:LoadVars = new LoadVars();
 send_lv.indexNum = iniIdx;
 send_lv.sendAndLoad(dataURL+"loadtoflash.php",result_lv,"POST");
};

: 텍스트필드 콤포넌트 : idx_txt, subject_txt,name_txt,contents_txt,date_txt,view_txt
===================================================

loadtoflash.php  내용
---------------------------------------------------------

<?
##flash 변수 받기
$selectIdx = $indexNum;
##$selectIdx =2;
$conn = @mysql_connect("localhost","entermedia","enter") or die ("failed to connect.");
$status = mysql_select_db("entermedia");
if(!$status){
 print "failed to select DB.";
 exit;
}

$query = "select * from news";
$result = mysql_query($query);
if(!$result){
 $erronNo=mysql_errno();
 $errorMsg=mysql_error();
 echo "ERROR ";
 exit;
}
## 필드의 갯수
$fields = mysql_num_fields($result);
## 행의 갯수
$rows = mysql_num_rows($result);
## 지정한 행의 값 배열
for($i=0;$i < $fields;$i++){
 $row[$i] = mysql_result($result,$selectIdx,$i);
}
echo("n_idx=".$row[0]."&n_subject=".$row[1]."&n_name=".$row[2]."&n_contents=".$row[3]."&n_date=".$row[4]."&n_view=".$row[5]."&totalIdx=".$rows);

mysql_close($conn);

?>

소스파일

dbtest.fla

flash 파일