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

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(dob) $numover

[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 top. I

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 Linux

[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 :

[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:

[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: 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 working

[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 in

[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: 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 that

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-oci8 configures for

[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? http://www.php.net/manual/ - 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] 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, http://freshmeat.net/projects/mdbtools/ might help. Regards... Michael -- PHP

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. http://lists.php.net/article.php?group=php.installarticle=12457 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's

[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;