[PHP-DB] Re: [PHP] Oracle + PHP

2004-01-30 Thread Michael Mauch
Luis Moran Ochoa wrote: > ORACLE_SID=OWEB ;export ORACLE_SID; > ORACLE_HOME=/usr/oracle/product; export ORACLE_HOME; > TNS_ADMIN=/usr/oracle/product/network/admin; export TNS_ADMIN; > ORACLE_BASE=/usr/oracle; export ORACLE_BASE; > ORA_NLS33=/usr/oracle/product/oc

Re: [PHP-DB] oracle compilation with php

2004-01-07 Thread Michael Mauch
Douglas B. Jones wrote: > I did not see an answer on php-install. > I have also tried oci8, > but I get the error mentioned at the bottom of my post. I have > the ORA_HOME set, both on the shell level and the makefile level. It

Re: [PHP-DB] Access db

2003-11-20 Thread Michael Mauch
Luke Van Blerk wrote: > I'll probably just extract the data with an access to mysql script and run > it on mysql. This is probably the best approach if you have access to Windows machine. If not, might help. Regards... Michael -- PHP Da

[PHP-DB] Re: Where To Go For Newbie Help?

2003-10-30 Thread Michael Mauch
Johnradio wrote: > where can i go to get total beginner's help? - look especially at the FAQ section and of course at the sections that you are interested in (Installation, Language Reference, you name it). Regards... Michael -- PHP Database Mailing

Re: [PHP-DB] Php433 running on RedHat73 with support to OCI8

2003-10-09 Thread Michael Mauch
Christopher Jones wrote: > Adriano Rocha wrote: > > > I'm running Linux RedHat7.3 with PHP 4.3.3. > >> root # > ./configure --with-oci8 (no errors) >> root # > make (no errors) >> root # > make install (no errors) >> >> ... it does not create the oci8.so file. That's perfectly normal. "--with-o

[PHP-DB] Re: Empty display loop...

2003-03-25 Thread Michael Mauch
Scott V Nipp <[EMAIL PROTECTED]> wrote: >I am working on a page that displays a line of information with a > checkbox at the end. I began by getting all of the information I wanted > displayed working properly and now I am adding the checkbox. Everything is > going find with the exception

[PHP-DB] Re: php, oracle, OCIExecute()

2003-03-24 Thread Michael Mauch
Marcin Wylot <[EMAIL PROTECTED]> wrote: > Warning: OCIStmtExecute: Error while trying to retrieve text for error > ORA-03120 in /var/www/html/oracle/index.php on line 62 This means that the Oracle libraries don't know where they can find the error messages - if they could find the error messages,

[PHP-DB] Re: Oracle + PHP + Linux Red Hat {again}

2003-02-06 Thread Michael Mauch
Alberto grájeda c. <[EMAIL PROTECTED]> wrote: > Connected to DataBase Oracle! > Warning: OCIStmtExecute: ORA-03106: fatal two-task communication protocol > error in /var/www/html/ora2.php on line 21 > > Warning: OCIFetchStatement: ORA-24374: define not done before fetch or > execute and fetch i

[PHP-DB] Re: Apache/php will not start after upgrading Oracle from 8.1.7.3 to 8.1.7.4

2003-01-19 Thread Michael Mauch
Miguel Ward <[EMAIL PROTECTED]> wrote: > Just upgraded my Oracle installation from 8.1.7.3 to 8.1.7.4. > > From that moment on, apache/php will not start (just hangs). > > Tried 'make'ing Apache and php again but same result. > > Checked oracle variables, etc and all seem to be okay (it was wor

[PHP-DB] Re: Passing variables through a page

2003-01-05 Thread Michael Mauch
Alex Francis <[EMAIL PROTECTED]> wrote: > I have a page (dept_select) with two drop down lists populated from a table > in a MySQL Database. If one item is selected in either of the lists I need > to go to one page (5-14_select_area.php). If any other item is selected I > need to go to another page

[PHP-DB] Re: PHP4.22/OCI8/Netscape 3.63 tnsnames problem...

2002-11-30 Thread Michael Mauch
David Leach <[EMAIL PROTECTED]> wrote: > If I specify the ORACLE_SID, and export it within my environment before > webserver startup, php/oracle do not look up the SID within > tnsnames.ora. I verified this with truss: > > Trace output: > Fatal NI connect error 12545, connecting to: > > (DESCRI

[PHP-DB] Re: OCIBindByName with Oracle 8i17 problem ?!

2002-11-04 Thread Michael Mauch
Fabien Joseph <[EMAIL PROTECTED]> wrote: > I discovered recently that it was impossible to bind an output > placeholder plsql (an input work only). > > Configuration 1 : Suse + Oracle 8i17 + oci (oracle) + PHP4.2.3 > Configuration 2 : HPUX11 + Oracle 8i17 + oci(oracle) + PHP4.2.3 > Configuration 3

Re: [PHP-DB] Converting database from MS Access to MySQL on Linux

2002-10-29 Thread Michael Mauch
Matthew Hildebrand <[EMAIL PROTECTED]> wrote: > http://www.devhood.com/Tools/tool_details.aspx?tool_id=759 > I've been very happy with this tool, and it is well worth the cost. If you are the author of the tool, you want perhaps add a note that "the tool" can convert _from_ Access _to_ MySQL on L

[PHP-DB] Re: Custom Sort Order in MySQL

2002-10-19 Thread Michael Mauch
Steve Vernon <[EMAIL PROTECTED]> wrote: >Just wondering what is the best way to get some data out of a >database in cutom order. > >They all have grades like A*, A, B, C and some are grade Secret. > >If I sort them by grade secret is at the bottom, I would like this >at the

[PHP-DB] Re: MySql problem..............

2002-10-15 Thread Michael Mauch
Rodrigo <[EMAIL PROTECTED]> wrote: > I need import some data from a Paradox table, i used the script below, > it worked just fine..but all the data was imported without the " ç > or á or é ", understand??? portuguese words all this changes to > some wierd caracter is there a way to fi

Re: [PHP-DB] Birthdays!

2002-10-14 Thread Michael Mauch
John W. Holmes <[EMAIL PROTECTED]> wrote: > There has to be a better way than this, but this is what I came up with > before dinner... > > $dayofyear = date("z"); > $daysinyear = (date("L"))?366:365; > > $numover = ($dayofyear + 14) - $daysinyear > > if($numover > 0) > { >$sql = "DAYOFYEAR

Re: [PHP-DB] Fatal error: Call to undefined function: mysql_conne ct() ......

2002-10-14 Thread Michael Mauch
Bhavin Vyas <[EMAIL PROTECTED]> wrote: > I am using "mysq". I tried to re-install using rpm, but didn't work. Will > need to recompile. However, now, I am getting "Mysql not loaded". My feeling > is that there must be a simple way to load this module, just don't know how > :-( You have to use e