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

2001-10-29 Thread Ricky Theil
the table -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 in

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 Message--

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 PROTECTED],

[PHP-DB] Other ODBC driver besides an openlink one?

2001-10-04 Thread Ricky Theil
We have had nothing but problems with our openlink drivers connecting to an oracle database from our bug tracking software, so I'm not allowed to use openlink odbc drivers. Is there another way to set up an odbc connection to a linux system using php and odbc??? I know I can do native connections,

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

2001-10-03 Thread Ricky Theil
I apologize... I'm wrong... $PHP_SELF is only the name of the current script... -Original Message- From: Ricky Theil [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 03, 2001 3:35 PM To: 'Sheridan Saint-Michel'; Francisco Carvalho; [EMAIL PROTECTED] Subject: RE: [PHP

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 the

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]' Subjec

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 becaus

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

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 -Origina

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] mssql functions on unix

2001-09-26 Thread Ricky Theil
ething I'm 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 The

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

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