Re: Pull Down Menu with ODBC query

Thanks everyone for your help so far. The last two responses I got were great and worked. However I stuck with my original script with the small $row fix presented earlier and it works great. The only problem I see with the last two are that there is no scripting to push to the next page like I have set. Saying that here is what I currently have: <?php $conn = odbc_connect("HOMES", "", ""); $billdate = $_POST[ 'billdate' ]; $query = ("SELECT DISTINCT sls_his_cust_id FROM sls_his where sls_his_prchdat_alt = $billdate"); $result = odbc_exec($conn, $query); echo "<form method=post action=getcustdata.php>"; echo "<SELECT name=sls_his_cust_id>"; while($row = @odbc_fetch_array($result)) { echo "<OPTION VALUE=\"$row[sls_his_cust_id]\">$row[sls_his_cust_id]</OPTION>"; } echo "</SELECT><INPUT TYPE=submit name=sls_his_cust_id VALUE=\"Get Data\"></FORM>"; ?> I need to know how to name the selection so I can push it to the next page using the submit button. The next page so far is as follows: <?php $conn = odbc_connect("HOMES", "", ""); $sls_his_cust_id = $_POST[ 'sls_his_cust_id' ]; $query = ("SELECT sls_his_d2_nam, cust_phone_no, cust_phone_no_2, cust_phone_no_3, sls_his_invc_no, sls_his_so_bdat, sls_his_d2_adrs_1, sls_his_d2_adrs_2, sls_his_d2_city, sls_his_d2_state, sls_his_d2_zip_cod, slm_nam, sls_his_pft_ctr, sls_his_prchdat_alt FROM sls_his , cust , slm where CUST_ID = SLS_HIS_CUST_ID AND slm = sls_his_slm_1 and sls_his_cust_id = $sls_his_cust_id"); $result = odbc_exec($conn, $query); odbc_result_all($result) ?> I need to be able to pass the selected CUSTID on to this page so I can display all the data pertinent to that customer... also I would like to be able to use the billdate that was present earlier but am not sure how to push it through again...