RE: [PHP-DB] Pull Down Menu with ODBC query

2008-08-11 Thread kitfox69
BTW I want to make sure I am doing this correctly... with that current script (edited below with your fix) will I be able to pass that selection on into a further PHP page? I do not see how without assigning a variable to it and passing it with POST... how would I go about this? --

Re: [PHP-DB] Pull Down Menu with ODBC query

2008-08-11 Thread Dan Shirah
Try something like this: tddiv 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

Re: [PHP-DB] Pull Down Menu with ODBC query

2008-08-11 Thread kitfox69
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