I am having trouble getting this script to populate the query data into a pull down menu.

The SQL script works fine and displays the data with odbc_result_all but will not put it in the menu.

Script is as follows:

<?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=column_name>";
while($row = [at] odbc_fetch_array($result))
{
echo "<OPTION VALUE=\"$row[0]\">$row[0]</OPTION>";
}
echo "</SELECT><INPUT TYPE=submit name=submit VALUE=\"Get Results\"></FORM>";
?>

Any ideas?

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

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?
-------------- Original message ----------------------
From: "Simcha" <simcha [at] syounger.com>
>
> odbc_fetch_array() returns an associative array, so will you need to use
> $row[' sls_his_cust_id'] instead of $row[0].
>
>
>
> -----Original Message-----
> From: kitfox69 [at] comcast.net [mailto:kitfox69 [at] comcast.net]
> Sent: Monday, August 11, 2008 10:14 PM
> To: php-db [at] lists.php.net
> Subject: [PHP-DB] Pull Down Menu with ODBC query
>
> I am having trouble getting this script to populate the query data into a
> pull down menu.
>
> The SQL script works fine and displays the data with odbc_result_all but
> will not put it in the menu.
>
> Script is as follows:
>
> <?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=column_name>";
> while($row = [at] odbc_fetch_array($result))
> {
> echo "<OPTION VALUE=\"$row[sls_his_cust_id]\">$row[sls_his_cust_id]</OPTION>";
> }
> echo "</SELECT><INPUT TYPE=submit name=submit VALUE=\"Get
> Results\"></FORM>";
> ?>
>
> Any ideas?
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
> No virus found in this incoming message.
> Checked by AVG - http://www.avg.com
> Version: 8.0.138 / Virus Database: 270.6.0/1604 - Release Date: 11/08/2008
> 05:50
>


--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

------=_Part_78757_29289583.1218488261475
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

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 = [at] 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>

------=_Part_78757_29289583.1218488261475--

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 = [at] 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...

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php