I have successfully inserted data into a table using odbc(/DBF4) The Problem is I have another form to query after insert
//
$conn_dbf = odbc_connect($dbf_host,$dbf_user,$dbf_pass);
echo '<select name="Farm_ID">';
$results= odbc_exec( $conn_dbf, "select Farm_ID,Farm_IDf from Farm_coo Order by Farm_ID" );
while (odbc_fetch_row( $results ))
{
$id= odbc_result( $results, 1 );
$idname= odbc_result( $results, 2 );
echo "<option value=\"$id\">$id --- $idname</option>\n"; //and place it in the select
}
echo "</select>";
odbc_close( $conn_dbf);
// this code will generate list box.
Why my listbox does not update (miss new inserted or edited)
I need to do something such as refresh IE many many times
Please Help me :>
I'm so young in PHP
Thank you very much.