Anyone know how I can list the field names of my database as opposed to the data?
The following code is what I started to right, but then realized that I want to populate the drop down list with the Field NAME not the Field Data...
<?
//Connect to the Database
$A = $PATH_TRANSLATED;
$B = strrev ($A);
$C = strstr ($B ,'\');
$D = strrev ($C);
$D = $D."db"."\"."\";
//echo $D." - ";
$dbc = new COM("ADODB.Connection");
$cnn = "DRIVER={Microsoft Access Driver (*.mdb)};";
$cnn .= "DBQ=".$D."msl.mdb;uid=;pwd=;";
//echo $cnn;
if (!$cnn)
{
?>
<font face="Arial, Helvetica, sans-serif" size="2">
Unable to connect to database at this time.
</font>
<?
}
//Connect to the Database ...END
?>
<?
$dbc->open($cnn);
$rsSelect = $dbc->execute("SELECT * FROM [Intra]");
?>
<form action="<?=$PHP_SELF?>" method="post">
<select name="Value1">
<?php while(!$rsSelect->eof()) { ?>
<option value="value"><?=$rs->fields['Notes']->value(); ?></option>
<?php $rsSelect->movenext(); } ?>
</select>
</form>
