[PHP-DB] PHP 4.05 Oracle 8

2001-09-19 Thread Ricky Theil
I need to set up PHP to work on a Windows 2000 machine with IIS 5, PHP 4.05 and Oracle 8.0.5 installed. I was having problems with the connection and kept getting all kinds of errors about the TNSNAMES file, but now I'm getting this error. Warning: _oci_open_server: ORA-12699: Native service

[PHP-DB] mssql functions on unix

2001-09-26 Thread Ricky Theil
Where do these functions come from on a unix box? I've never had to connect to a mssql DB from a unix machine, but have run into the point where I must. I have plenty of scripts on a windows machine connecting to a mssql DB, but I don't see a configure option to include the mssql functions when

RE: [PHP-DB] mssql functions on unix

2001-09-26 Thread Ricky Theil
missing?? Here's the configure I ran: ./configure --with-mysql=/usr/local/mysql --with-apache=../apache_1.3.19 --with-sybase --enable-track-vars -Original Message- From: Andrew Hill [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 26, 2001 10:48 AM To: Ricky Theil; [EMAIL PROTECTED

RE: [PHP-DB] Huw do I perform update? I missed the accual code bit.. sorry

2001-09-26 Thread Ricky Theil
I have no problem updating integer and float fields when putting them in '' if you update an integer with a blank value, it makes the value in the db =0. always on unix and mysql, though. Ricky -Original Message- From: Brian Paulson [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September

RE: [PHP-DB] Cybercash? or Who?

2001-10-03 Thread Ricky Theil
I just recently started using Cardservice International for all my precessing. The only drawback was that I had to purchase an API wrapper, but it is a PHP wrapper. It was $95. It's extremely fast, and easy to use. Documentation isn't the best, but their support is awesome! Ricky

RE: [PHP-DB] Bug in new PHP Version?

2001-10-03 Thread Ricky Theil
Looks like you've got the answer to your question, right there use mysql_select_db() and mysql_query() instead. I use 4.06 and have never used the mysql_db_query function. -Original Message- From: Luditus [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 03, 2001 2:13 AM To:

RE: [PHP-DB] Performance boosting

2001-10-03 Thread Ricky Theil
There is a certain amount of the script that the browser can display before the script is done loading. I'm not sure exactly how much that is, but I've seen this before. I wrote a script that pulls info out of a mssql DB, and it shows the top part of my script while pulling DB info. It's

RE: [PHP-DB] what's the current URL

2001-10-03 Thread Ricky Theil
Use the phpinfo(); function to show you all the environment variables. i.e. the current file URL w/o the query string on it is $PHP_SELF Ricky -Original Message- From: Francisco Carvalho [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 03, 2001 2:51 PM To: '[EMAIL PROTECTED]'

RE: [PHP-DB] what's the current URL

2001-10-03 Thread Ricky Theil
$PHP_SELF returns the full URL of the current script. i.e. $PHP_SELF http://domain.com/script.php -Original Message- From: Sheridan Saint-Michel [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 03, 2001 3:30 PM To: Francisco Carvalho; [EMAIL PROTECTED] Subject: Re: [PHP-DB] what's

RE: [PHP-DB] Subject: RE:Please Confirm!! Yes I want to Optin RE: php-db@lists.php.net

2001-10-05 Thread Ricky Theil
Obviously someone pretty smart. -Original Message- From: Sterling [mailto:[EMAIL PROTECTED]] Sent: Friday, October 05, 2001 2:47 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] Subject: RE:Please Confirm!! Yes I want to Optin RE: [EMAIL PROTECTED] Importance: High You [EMAIL

RE: [PHP-DB] HELP PLEASE!! Get query error when inserting into MySql

2001-10-29 Thread Ricky Theil
If your first field is an auto insert field, then you have to do it like this: insert into tablename (column2,column3,column4,column5) values (value2,value3,value4,value5) The auto incremented field will be automatically be filled in with the next available value. Ricky -Original

RE: [PHP-DB] HELP PLEASE!! Get query error when inserting into My Sql

2001-10-29 Thread Ricky Theil
-Original Message- From: Ricky Theil [mailto:[EMAIL PROTECTED]] Sent: Monday, October 29, 2001 10:26 AM To: '[EMAIL PROTECTED]'; Robby Whiteside; [EMAIL PROTECTED] Subject: RE: [PHP-DB] HELP PLEASE!! Get query error when inserting into My Sql If your first field is an auto insert field, then you have