[PHP-DB] Re: [Q] PHP on Linux, Oracle on Win32

2001-08-02 Thread Philippe Saladin
ora_logon and friends are the old way to connect to Oracle. With Oracle 8, we should use the OCI functions (ocilogon, ...) Philippe Hugh Bothwell [EMAIL PROTECTED] a écrit dans le message news: [EMAIL PROTECTED] Donovan J. Edye [EMAIL PROTECTED] wrote in message [EMAIL

[PHP-DB] Re: PHP redirect?

2001-08-02 Thread Johannes Janson
Hi, I have a form and based off of this form if my user selects option a then I want them to be redirected to another page. If they select option B then I want to continue with my php scrips as it does now. Does any one have any ideas on how I can accomplish this? use the header() function

[PHP-DB] Re: SQL Error

2001-08-02 Thread Johannes Janson
Hi, [...] Any ideas? $add_contact_sql = INSERT INTO $table_name (ContactID, FirstName, LastName, Title, WorkPhone, HomePhone,Mobile,EmailName,Birthday,CompanyID) VALUES ('', '$FirstName', '$LastName', '$Title', '$WorkPhone', '$HomePhone', '$Mobile', '$EmailName', '$Birthday',

[PHP-DB] Re: SQL Error

2001-08-02 Thread Steve Fitzgerald
Steve Fitzgerald [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... I keep getting the following SQL error: The last fieldname is CompanyID not ContactID. You have an error in your SQL syntax near ')' at line 14 Line 14 is: '$FirstName', so the error must

[PHP-DB] SQL Error

2001-08-02 Thread Steve Fitzgerald
I keep getting the following SQL error: You have an error in your SQL syntax near ')' at line 14 Line 14 is: '$FirstName', so the error must correspond to a different part of the code. Any ideas? $add_contact_sql = INSERT INTO $table_name (ContactID, FirstName, LastName, Title, WorkPhone,

Re: [PHP-DB] SQL Error

2001-08-02 Thread Martin Lefebvre
Have you tried with NULL instead of '' the ContactID? On Thu, 2 Aug 2001, Steve Fitzgerald wrote: I keep getting the following SQL error: You have an error in your SQL syntax near ')' at line 14 Line 14 is: '$FirstName', so the error must correspond to a different part of the code. Any

[PHP-DB] Slow php processing

2001-08-02 Thread Faye Keesic
Hi there, In the past 24 hours, my php pages for one site have gone from 2 seconds loading time to nearly 2 minutes. What may have caused this degradation? I have not modified any of my php code, so think it may be a problem on the server, or with the database. However, not all my php

RE: [PHP-DB] PHP redirect?

2001-08-02 Thread Dave Watkinson
I've changed what I originally answered with, assuming option 1 has the value 12 (as you describe) and option 2 has value 14... ? if $option_button == 1) { header(Location: some_page_or_other.php?12); } else { header(Location: some_other_page_you_choose.php?14); } ? then you can get that value

[PHP-DB] MySQL support

2001-08-02 Thread [EMAIL PROTECTED]
Hi everyone ! I've installed Apache 1.3.20, MySQL 3.23.38 and PHP 4.0.6 with MySQL support but I still have : MySQL a répondu: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) when trying to connect to the database with phpMyAdmin 2.2 Is there a way to

[PHP-DB] Re: PHP redirect?

2001-08-02 Thread Phillip Bow
JavaScript would allow them to immediately be sent to the page. -- phill Webmaster [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... I have a form and based off of this form if my user selects option a then I want them to be redirected to another page. If they

[PHP-DB] ORACLE .... And Tns

2001-08-02 Thread C.Chassagneux
I have a simple script in php : putenv(ORACLE_HOME=D:\\ORANT); putenv(TNS_ADMIN=D:\\ORANT\\NETWORK\\ADMIN); putenv(ORACLE_SID=x); echo Oracle : . getenv(ORACLE_HOME). \n; echo TNS_ADMIN : . getenv(TNS_ADMIN). \n; echo ORACLE_SID : . getenv(ORACLE_SID). \n; $connect_oracle =

RE: [PHP-DB] Trouble with PHP/MYSQL/APACHE

2001-08-02 Thread Dave Watkinson
looks like your include path and/or file don't exist. Double check that colon before /usr - surely that's incorrect? The undefined function is probably because the include file can't be found. Dave -Original Message- From: Al Moote [mailto:[EMAIL PROTECTED]] Sent: 02 August 2001 20:06

RE: [PHP-DB] mySQL Autoincrement Field

2001-08-02 Thread Chris
Hi Ralph, Here is how I do it, which is how you suggested. Regards, Chris... #-- CREATE TABLE `test` ( `id` int(11) NOT NULL auto_increment, `browser` varchar(255) NOT NULL default '', PRIMARY KEY (`id`) ); INSERT INTO test VALUES