[PHP-DB] PHP Self pages

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

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

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? --

[PHP-DB] Pull Down Menu with ODBC query

2008-08-11 Thread kitfox69
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: "; echo ""; while($row = @odbc_fetch_array($result)) { echo "$row[0]"; } echo

Re: [PHP-DB] PHP5 and Multiple Database Connections

2008-08-05 Thread kitfox69
Here are the messages that are currently displayed and my current script: Warning: odbc_connect() [function.odbc-connect]: SQL error: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified, SQL state IM002 in SQLConnect in D:\xampp\htdocs\test2.php on line 11

Re: [PHP-DB] PHP5 and Multiple Database Connections

2008-08-05 Thread kitfox69
Yes I am sure the ODBC works as it is installed on my laptop and I use Excel to import many various queries of data. -- Original message -- From: Micah Gersten <[EMAIL PROTECTED]> > Have you tested the DSN outside of PHP? Openoffice.org Database has > facilities t

[PHP-DB] PHP5 and Multiple Database Connections

2008-08-05 Thread kitfox69
Hello Everyone! I am currently writing a sequence of php pages to help me retrieve data from a Pervasive 9.5 database, display that data in my web browser with a form built in to collect more data, and then will push the retrieved Pervasive data and the input data to MySQL. I am having problem