Try this: http://xajaxproject.org/
Thank you, Micah Gersten onShore Networks Internal Developer http://www.onshore.com [EMAIL PROTECTED] wrote: > I have three PHP pages that post data to each consecutive page. > > I would like the second page, the one with a pull down menu of customer ids, > to spawn itself onto the next page so that the person using it would not have > to click back to choose the next customer id. > > Currently the first page captures and posts a date to the second page and the > second page generates the pull down with values and has a get data submit > button to forward to the third page where all the data is displayed. > > How can I merge the second and third page together so that once a value is > selected in the pull down and then the get data button is clicked it just > populates the data right next to the pull down? > > Script for page 2 and 3 below: > > PAGE2: > <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" > "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd";> > <html xmlns="http://www.w3.org/1999/xhtml";> > <head> > <title>Today's Customers</title> > <meta http-equiv="content-type" > content="text/html; charset=iso-8859-1" /> > </head> > <body> > <?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=custid VALUE=\"Get Data\"></FORM>"; > ?> > </body> > </html> > > PAGE3: > <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" > "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd";> > <html xmlns="http://www.w3.org/1999/xhtml";> > <head> > <title>Customer Information</title> > <meta http-equiv="content-type" > content="text/html; charset=iso-8859-1" /> > </head> > <body background="afi.jpg"> > <?php > $conn = odbc_connect("HOMES", "", ""); > $sls_his_cust_id = $_POST[ 'sls_his_cust_id' ]; > $query1 = ("SELECT DISTINCT sls_his_d2_nam as 'Customer Name', > cust_phone_no as 'Phone Number 1', > cust_phone_no_2 as 'Phone Number 2', > cust_phone_no_3 as 'Phone Number 3' > FROM sls_his , cust > where CUST_ID = SLS_HIS_CUST_ID > and sls_his_cust_id = '$sls_his_cust_id'"); > $query2 = ("SELECT DISTINCT sls_his_pft_ctr as 'Profit Center', > UPPER(slm_nam) as 'Sales Person' > FROM sls_his, slm > where sls_his_slm_1 = slm > and sls_his_cust_id = '$sls_his_cust_id'"); > $query3 = ("SELECT sls_his_item_id as 'Item ID', > sum(sls_his_qty_sld) as 'Quantity Sold', > sls_his_prchdat_alt as 'Billed Date' > FROM sls_his > where sls_his_cust_id = '$sls_his_cust_id' > Group by sls_his_item_id, sls_his_prchdat_alt > Order by sls_his_prchdat_alt"); > $result1 = odbc_exec($conn, $query1); > $result2 = odbc_exec($conn, $query2); > $result3 = odbc_exec($conn, $query3); > odbc_result_all($result1) > > ?> > </BR> > <?php > odbc_result_all($result2) > > ?> > </BR> > <?php > odbc_result_all($result3) > > ?> > </body> > </html> > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
