Re: Pull Down Menu with ODBC query
| From: | Dan Shirah | Date: | Mon, 11 Aug 2008 20:57:41 +0000 |
| Subject: | Re: Pull Down Menu with ODBC query | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-45201@lists.php.net to get a copy of this message | ||
Try something like this:
<td><div align="right">
<SELECT name="menu">
<?php
$conn = odbc_connect("HOMES", "", "");
$billdate = $_POST[ 'billdate' ];
$q_menu = "SELECT DISTINCT sls_his_cust_id FROM sls_his where
sls_his_prchdat_alt = $billdate";
$r_menu = odbc_exec($conn, $q_menu);
while ($rec_menu = @odbc_fetch_array($r_menu)) $menu[] = $rec_menu;
echo "<OPTION value=\"\">--SELECT--</OPTION>\n";
foreach ($menu as $m)
{
if ($m['sls_his_cust_id'] == $_POST['menu'])
echo "<OPTION value=\"{$m['sls_his_cust_id']}\"
SELECTED>{$m['sls_his_cust_id']}</OPTION>\n";
else
echo "<OPTION
value=\"{$m['sls_his_cust_id']}\">{$m['sls_his_cust_id']}</OPTION>\n";
}
?>
</SELECT>
</td>