Re: [PHP-DB] PHP - Oracle 7.3.4 - ORA-12154

2003-02-06 Thread Maxim Maletsky
add the failover directive in tnsnames.ora. Find how to on the web (not sure right now) -- Maxim Maletsky [EMAIL PROTECTED] On Fri, 07 Feb 2003 02:15:43 + Maron Kristófersson <[EMAIL PROTECTED]> wrote: > Hello! > > I set up PHP on a Sun Solaris box a week ago (see phpinfo output below).

[PHP-DB] PHP - Oracle 7.3.4 - ORA-12154

2003-02-06 Thread Maron Kristófersson
Hello! I set up PHP on a Sun Solaris box a week ago (see phpinfo output below). It has oracle 7.3.4 and php 4.0.4pl1 so I'm using the --with-oracle configure option. Due to a special module we're using we're stuck with using that php version (4.0.4pl1). At first I was getting the ORA-12154 TNS

Re: [PHP-DB] $_FILES missing path

2003-02-06 Thread Squirrel User
I searched for PHP script for selecting a file, but couldn't find small simple ones. Well, I could write a script using opendir() and link a url to each. Geez, but I was hoping that someone has already done that... Quoting Squirrel User <[EMAIL PROTECTED]>: > ENCTYPE="multipart/form-data">

RE: [PHP-DB] how do I use same page for submit and results?

2003-02-06 Thread Luke Woollard
or you can use check for the name of the submit button using a specific SUPERGLOBAL array. e.g. if ( ! empty($_POST["submit"]) ) { /* form was submitted */ } else { /* form hasn't been submitted, show it */ echo '' .' form fields/button goes here ' .'' .''

RE: [PHP-DB] Weird PHP behavior...

2003-02-06 Thread NIPP, SCOTT V (SBCSI)
It turned out to be just a simple file permissions issue. -Original Message- From: Mohammad Saad [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 06, 2003 12:31 PM To: NIPP, SCOTT V (SBCSI); [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: [PHP-DB] Weird PHP behavior... Check

[PHP-DB] Time entry program

2003-02-06 Thread Marie Osypian
Hi, I was looking for a basic time entry program for people to sign-in and sign-out. Like a time clock for example. Does anyone know of one out there already? Thanks, Marie -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[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

Re: [PHP-DB] Weird PHP behavior...

2003-02-06 Thread Mohammad Saad
Check path on this require require_once("/www/DW/prod.lib.php"); something is wrong with this - Original Message - From: "NIPP, SCOTT V (SBCSI)" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Thursday, February 06, 2003 10:17 PM Subject: RE: [PHP-DB] Weird PHP behavi

Re: [PHP-DB] how do I use same page for submit and results?

2003-02-06 Thread Joshua Stein
> But now I'm not using anything that I can check except for the > button click. Any ideas how to do this? assign a name to the button and check for that. ... if ($_REQUEST["action"] == "Show List") { /* form was submitted */ ... } else { /* form hasn't been submitted, show it */ .

Re: [PHP-DB] Remnant data from previous queries when using mysql_fetch_array...

2003-02-06 Thread Doug Thompson
On Thu, 06 Feb 2003 10:33:23 -0700, Doug Thompson wrote: >Try getting the results from the query like the following. -snip- With the correct syntax. 8-( Doh! > >// >$numrows = mysql_num_rows ($result); > ^ -- PHP Database Mailing List (http:

Re: [PHP-DB] Remnant data from previous queries when using mysql_fetch_array...

2003-02-06 Thread Doug Thompson
Try getting the results from the query like the following. Doug // generate and execute query $query = "select * from changelog where changedBy = '$changedBy' or vendorNumber = '$vendorNumber' or oldName like '$oldName' or newName like '$newName' or newVendorNumber = '$newVendorNumber'"; $result

[PHP-DB] how do I use same page for submit and results?

2003-02-06 Thread John A DAVIS
On my choices page, there are only 3 radio buttons and a Submit button. The page calls itself and runs a query on the database, displaying results. But the criteria buttons are still at the top of the page above the results. Before, I had a combo box for certain choices and I just did an "If (!$

RE: [PHP-DB] Weird PHP behavior...

2003-02-06 Thread NIPP, SCOTT V (SBCSI)
Here is the working code... 7) { $sql = mysql("Calendar2","SELECT B.Title, UNIX_TIMESTAMP(A.StartDate), UNIX_TIMESTAMP(A.StopDate) FROM `phpCalendar_Details` AS B, `phpCalendar_Daily` AS A WHERE A.CalendarDetailsID = B.CalendarDetailsID AND CURDATE() BETWEEN A.StartDate AND A.StopDate"

[PHP-DB] Re: Something is fishy in my selection

2003-02-06 Thread Mathieu Dumoulin
Oh crap, someone mailed me about having nulls in my field compared... you can no disregard this thread...its closed i got the culprit, it's a stupid NULL i found in a column Mathieu Dumoulin "Mathieu Dumoulin" <[EMAIL PROTECTED]> a écrit dans le message de news: [EMAIL PROTECTED] > More info on t

[PHP-DB] Re: Something is fishy in my selection

2003-02-06 Thread Mathieu Dumoulin
More info on this problem, i tried running the queries (the NOT IN and the IN) while TRIM() the field compared just to see and i did that in a web page directly thru the mysql<=>php api. Results: Trimming and using in list: 6286 Trimming and using not in list: 7 Not trimming and using in list: 6

[PHP-DB] Weird PHP behavior...

2003-02-06 Thread NIPP, SCOTT V (SBCSI)
I developed some dynamic content for a larger web page, and once I pasted the code into the appropriate area of the page I am seeing the strangest error. Here is the error: Warning: Failed opening '/www/DW/index1.htm' for inclusion (include_path='.:/usr/local/lib/php') in Unknown on line

[PHP-DB] Something is fishy in my selection

2003-02-06 Thread Mathieu Dumoulin
Hi there, want to say this right off the start the calculations here are used with the totals of the results and not the range so dont go telling me that i might have used a 0 based index, NO... I have 6294 lines in my table i query with a IN (...) statement and i get 6286 lines out of my DB i que

Re: [PHP-DB] Remnant data from previous queries when using mysql_fetch_array...

2003-02-06 Thread Mike Hilty
Okay, I figured out that the issue is not due to the PHP code, but by the query I'm using against the MySQL DB... What I need to know is how to structure the code where the query is based off of fields filled in by the user. I would like to structure the query where if the user provides a value f

Re: [PHP-DB] PHP Database Abstraction Layer

2003-02-06 Thread Maxim Maletsky
"Luke Woollard" <[EMAIL PROTECTED]> wrote... : > I once read a great article in the first or second issue of > http://www.phparch.com/ on database abstraction layers. At which point I > used the tutorial as a starting point for creating a very similar structure > I named dbWave. There are only mi

[PHP-DB] Re: Argh ! array help required :(

2003-02-06 Thread Nenad Djordjevic
Hello Aaron, * Try code like: for ($i=0; $i Product 1 Product 2 Product 3 Product 4 Product 5 Best regards, Nenad Djordjevic mailto:[EMAIL PROTECTED] Diyomi Soft http://www.diyomisoft.com/