I'm new to all this and I'm slowly trudging my way through, but what I've got is an html form, named ORDERHDR, that contains an iframe. The iframe calls a php script that connects to a database & returns data in the form of a select/combobox. Then when the user chooses one of the options within the select/combobox I need to return that to the parent page. Most of this is working, except I'm not getting any value returned to the parent page; all I get is an undefined value. I'm not sure what I'm doing wrong so I could sure use some help. I've included below the javascript in the parent page that I'm attempting to use to retrieve the selection from the iframe; I've also included the html snippet that creates the iframe, and the php text that is within the iframe. Thanks for any help!
Code:<script language="JavaScript" type="text/javascript"> function getshiptoid(string) { var shiptoid=string; alert(shiptoid); ORDERHDR.SHIPTOID.value = shiptoid; alert(ORDERHDR.SHIPTOID.value); } </script>HTML Code:<td width="423"><iframe width="500" name="shiptoids" frameborder="0" height="25" align="middle" marginheight="0px" marginwidth="0px" src="http://netlink.proformsknox.com/nlhtml/custom/selecttest.php?requestorid=@VAR_REQR_ID_@">Your browser does not support iframes</iframe></td>PHP Code:<?php
$connection = odbc_connect('phptest2','','');
if (!$connection) {
die("Could not open connection to database server");
}
// generate and execute a query
$requestorid = $_GET["requestorid"];
$query = "SELECT shipto.shiptoid, shipto.shiptoname, shipto.address1, shipto.city, shipto.state, shipto.zipcode, nl_logon.shiptoid FROM shipto, nl_logon WHERE nl_logon.requestid = '$requestorid' AND shipto.shiptoid = nl_logon.shiptoid";
$result = odbc_exec($connection, $query);
echo "<select onchange=\"parent.getshiptoid($shiptoid);\">";
while ($rows = odbc_fetch_row($result)) {
$shiptoid = odbc_result($result, "shiptoid");
$shiptoname = odbc_result($result,"shiptoname");
$address1 = odbc_result($result,"address1");
$city = odbc_result($result,"city");
$state = odbc_result($result,"state");
$zipcode = odbc_result($result,"zipcode");
echo "<option onchange=\"onSelection(this.options[this.selectedIndex].value)\">";
echo "$shiptoname ";
echo "$address1 ";
echo "$city ";
echo "$state ";
echo $zipcode;
echo "</option>";
}
odbc_close($connection);
echo "</select>";
?>


Reply With Quote
Bookmarks