Hi,
I got no problem insert record to mysql thru the html text block.
But i got problem using html option text block.
Pls find below is part of my script. I can't give all cause hard to see.
--CONNECTION AND SELECT STMT OF THE OPTION TEXT --
include('c:/adodb/adodb.inc.php');
$conn2 = ADONewConnection('mysql');
$conn2->Connect("localhost","shah","shah","haccp");
$sql2 = "SELECT * FROM state_table";
$recordSet = $conn2->Execute($sql2);
while (!$recordSet->EOF) {
$os = $recordSet->fields[1];
$option_block .= "<OPTION value=\$os\">$os</OPTION>";
$recordSet->MoveNext();
}
$recordSet->Close();
$conn2->Close();
--THIS IS WHERE THE OPTION TEXT HAPPENED--
State:
<SELECT name="T5F">
<?php echo "$option_block"; ?>
</SELECT>
</font>
</td>
--INSERT STMT--
$sql = "INSERT INTO company_info (roc_no,state) VALUES ('$T1','$T5F')"; $conn1->Execute($sql);
When I checked the mysql database the record was inserting but the value for state field is nothing.
--shah
