php access Ôö¼Ó¼Ç¼

$conn=new com("ADODB.Connection");
$connstr="DRIVER={Microsoft Access Driver (*.mdb)};DBQ=".realpath("d:/web/tiku.mdb");
$conn->Open($connstr);
$rs = new com("ADODB.RecordSet");
$rs_1=new com("ADODB.RecordSet");
$rs->Open("select * from fill_table",$conn,1,1);
$rs_1->Open("select * from stud_answer_table",$conn,1,1);
ÕâÖÖ·½Ê½µÄÁ´½Ó
stud_answer_table ÊÇ¿ÕµÄ
ÎÒÏëÑ­»·Ôö¼Ó¼Ç¼ ¿ÉÊDz»Ì«»áÓÃsqlÓï¾ä ÀïÃæҲûÓÐaddnewÓï¾ä
ÇëÎʸÃÔõôд
INSERT INTO person (stud_id,question_type,question_id)
                VALUES ($number, 'fill_table', $rs->fields[0]);
insert Óï¾ä¾ÍÕâÑù

---

ºÜÉÙÈË»áPHP½áºÏACCESSÓõÄ

---

ÎÒÄÇÑùµÄ·½Ê½ ¶¼²»»áô£¿

---

$mmm="INSERT INTO stud_answer_table (stud_id,question_type,question_id)
                VALUES ('".$number."','".$type."',".$rs->fields[0].")";
Â¥ÉÏ˵µÄºÜ¶Ô
ÎÒȷʵsql php
¶¼²»ÊìϤ
²»¹ý »¹ºÃÕÒµ½·½·¨ÁË
ÈÔÈ»¸Ðл