Re: [PHP-DB] Difference between OCI* functions and ORA_* functions

2001-10-05 Thread Philippe Saladin
FYI, You can use OCI8 on a Oracle 7 database, if the net8 client is configured Regards, Philippe B. Perrine [EMAIL PROTECTED] a écrit dans le message news: [EMAIL PROTECTED] ORA are for Oracle7 OCI8 for Oracle8 Read the manual on www.php.net B. le jeu 04-10-2001 at 17:02 Sridhar Moparthy a

[PHP-DB] Oracle 9i?

2001-10-05 Thread Beau Lebens
Just looking at upgrading an existing application which is potentially turning from small-fry to enterprise level (aren't they all :P) and was wondering what the situation is on Oracle 9i support. I have never worked with Oracle/PHP together, but all I can find in the manual are the ORA and OCI8

Re: [PHP-DB] MS SQL 7

2001-10-05 Thread Ermanno Iannacci
Which way? I've tried with mssql_query, but it didn't work. Thanks. -- Initial message --- From: Frank M. Kromann [EMAIL PROTECTED] To : Ouster [EMAIL PROTECTED] Cc : [EMAIL PROTECTED] Date: Thu, 04 Oct 2001 12:17:18 -0700 Subject : Re: [PHP-DB] MS SQL 7

[PHP-DB] Sorting a 2 dimension array

2001-10-05 Thread John Clarke
I would like to sort a 2 dimensional array based on the value of one of the keys of each element. I have an array returned from a msql query which contains 10 records/elements and each record 5 fields/keys. I would like to sort the records based on the value of a particular field in each record.

Re: [PHP-DB] Sorting a 2 dimension array

2001-10-05 Thread Robert Gormley
Is ksort() what you're looking for? Sorts an array by key, maintaining key to data correlations. Robert At 05:31 PM 5/10/2001 +0930, John Clarke wrote: I would like to sort a 2 dimensional array based on the value of one of the keys of each element. I have an array returned from a msql query

RE: [PHP-DB] Sorting a 2 dimension array

2001-10-05 Thread Beau Lebens
although i've never used it, sounds like you would need to use the uasort() function, and write a custom comparison function - tho don't ask me how to do that :P HTH Beau // -Original Message- // From: John Clarke [mailto:[EMAIL PROTECTED]] // Sent: Friday, 5 October 2001 4:01 PM //

Re: [PHP-DB] Sorting a 2 dimension array

2001-10-05 Thread Steve Farmer
Hi, Why don't you sort the query to MYSQL and have the records delivered in the order you want them? HTH Steve At 5:31 PM +0930 5/10/01, John Clarke wrote: I would like to sort a 2 dimensional array based on the value of one of the keys of each element. I have an array returned from a msql

[PHP-DB] Speeding up database access

2001-10-05 Thread Rob\[UK\]
I am just starting out on a project that has to be multi-lingual. i.e. every word/sentence I output has to be translated. The user logs in, and I read the language they use, by looking at the user record. I then need to get the language translations from a database. I just select label, text

[PHP-DB] Re: Speeding up database access

2001-10-05 Thread Rob UK
I forgot to say, I am using Oracle OCI to access the database: : $sSQL = select label, text from language_text where language = 'English'; $stmt = OCIParse($conn,$sSQL); OCIExecute($stmt); $nrows = OCIFetchStatement($stmt,$results); -- PHP Database Mailing List (http://www.php.net/) To

[PHP-DB] Re: mysql - php DATE QUESTION...

2001-10-05 Thread _lallous
DELETE FROM tablename WHERE DATE_SUB(tablename.datefield, INTERVAL 30 DAY) NOW() Koutsogiannopoulos Karolos [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... Can someone offer some help...? Lets say i have a date collumn in a mysql table that includes dates that

[PHP-DB] bitshift

2001-10-05 Thread Bas Jobsen
Hello, bit_count(bit_or(1table1.sid)) can i use this on a field char(32)? i tried bit_count(bit_or(256table1.sid)) but it doesn't seem to work. (cause i thought 32byte is 8x32 bits) Best regards, Bas -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL

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

2001-10-05 Thread Andrew Hill
Hi Ricky, I wasn't able to find any open support cases for you. If you've had any problems with OpenLink drivers I'd like to know what they are so they can be resolved asap. Our drivers work quite well with Oracle, although there can be problems if database version is not matched exactly.

RE: [PHP-DB] updating records in ODBC with cursor

2001-10-05 Thread Andrew Hill
If your drivers suppport Cursors, then sure :) You can download OpenLink's for free - they come with a non-expiring 2-user license. There are 5 different cursor implementations in OpenLink's drivers, from Foward Only through Bidirectional to Dynamic. Best regards, Andrew Hill Director of

[PHP-DB] Re: PHP with Domino Notes

2001-10-05 Thread Carlos Augusto Abarca
One way to do this is using de ODBC functions, you would have to set up a OBDC conection using the appropiate drivers from lotus. -- == CARLOS AUGUSTO ABARCA B. Web Design Engineer Seguros Bolivar - TBF Sistemas Bogotá D.C.,

Re: [PHP-DB] Howto make a double LEFT JOIN

2001-10-05 Thread Sheridan Saint-Michel
- Original Message - From: Bas Jobsen [EMAIL PROTECTED] To: Sheridan Saint-Michel [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, October 04, 2001 7:17 PM Subject: Re: [PHP-DB] Howto make a double LEFT JOIN Hello Sheridan Saint-Michel, Well it works fine, tnx!!! But now i want

Re: [PHP-DB] Howto make a double LEFT JOIN

2001-10-05 Thread Bas Jobsen
Hello, okay... 1table1.sid is leftshift the number 1 table1.sid times. Your result will be a binary number... which will be the number 1 followed by table1.sid 0's. Once you have this you do a bitwise or of all the numbers you have shifted. This means any two rows where sid was the same

Re: [PHP-DB] Auto_increment field size (was: Howto make a double LEFT JOIN)

2001-10-05 Thread Sheridan Saint-Michel
- Original Message - From: Bas Jobsen [EMAIL PROTECTED] To: Sheridan Saint-Michel [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Friday, October 05, 2001 9:50 AM Subject: Re: [PHP-DB] Howto make a double LEFT JOIN snip ACK! Don't do this. You do know that an unsigned int (using a signed

[PHP-DB] Re: Interbase and php on win2k...

2001-10-05 Thread John Lim
Hi, It definitely is not running the dll. Run ? phpinfo(); ? and check that the interbase extension is loaded. See if any other extensions can be loaded by modifying php.ini. Check to see if you have multiple php.ini's and check your file/directory permissions. Persistence is the key. Bye,

[PHP-DB] Re: Speeding up database access

2001-10-05 Thread John Lim
Hi Check your indices are tuned. Personally, I feel that storing languages srings in arrays, particularly if you are using a cache like Zend/APC gives better performance. Bye, John Rob) [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... I am just starting out on

[PHP-DB] Re: Inserting CSV in MySQL

2001-10-05 Thread Eric Schmuttenmaer
1. Check for the special chars around the last entry as andre says. 2. Make sure your type and length of your type can hold the number of records you are importing. -- It's a good life, enjoy it. - Jim Hensen Eric Schmuttenmaer [[EMAIL PROTECTED]] --

[PHP-DB] array from html form

2001-10-05 Thread Larry Linthicum
Hi I'm just a PHP hobbiest trying to build a points calculating system for another hobby, please bear with me. I need to build a multidimensional array from a html form, the array would look like: $needed_data = array ( array (id = $member_id, points = $position ),

RE: [PHP-DB] array from html form

2001-10-05 Thread Charles Butler
For one, why are you redefining the array 3 times in that script? ... I'm trying to follow here... and its not making sense. -Original Message- From: Larry Linthicum [mailto:[EMAIL PROTECTED]] Sent: Friday, October 05, 2001 12:14 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] array from

Re: [PHP-DB] array from html form

2001-10-05 Thread Larry Linthicum
the subarrays contain variable data and I tried to express that by showing the array structure that way if I access $needed_data[0] it would be an array of two pieces of data ( both variable) $needed_data[1] would also be an array of two variable pieces of data, etc if I loop through them all

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

2001-10-05 Thread Sterling
You [EMAIL PROTECTED], or someone using your email [EMAIL PROTECTED] address, posted to my Blastomatic site. This is a one time emailing to ask you to verify your email address. Just reply to this email address to verify or follow the below instructions.

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] Subject: RE:Please Confirm!! Yes I want to Optin RE : php-db@lists.php.net

2001-10-05 Thread Francisco Carvalho
NOT STRICK ENOUGH?!? ** This email is sent in compliance with our strict anti-abuse regulations. We are attempting to verify your email address. This message is only a request to verify. It is not in any way to be construed as a commercial

[PHP-DB] Como crear usuarios reales de linux mediante php

2001-10-05 Thread Modem
Como crear usuarios reales de linux mediante php, estos usuarios no deben tener shell (Shell false). Gracias a quien me pueda ayudar -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the

[PHP-DB] Propuesta

2001-10-05 Thread Alfonso Vidales
Hola como estas estamos interesados en comprar publicidad en tu página mediante nuestro sistema de banners online. El cual consiste en que pongas un banner de MercadoLibre en tu site, y nosotros te pagamos 50 pesos por cada usuario que se registre de tu página a la nuestra activamente,

[PHP-DB] Talent Exchange? Need PHP Programmer

2001-10-05 Thread Marie
This could very well work into an ongoing working relationship, so please respond if you think you can help! HERE'S THE DEAL: I'm looking to exchange my extensive website design and graphic skills with someone with PHP or Cold Fusion skills that can help finish the backend database for a Real

[PHP-DB] order by a count of another table

2001-10-05 Thread Noah Spitzer-Williams
hey guys, i want to show a list of rows from a table sorted by the count of another table. the first table has a username field and so does the other table. so i want to sort the first table by how many rows that has the username from the other table. so something like this although i

[PHP-DB] Re: Interbase and php on win2k...

2001-10-05 Thread Christian C.
Ok im getting some where the Ib dll is finaly getting loaded But now the php is giving me av (the memory could not be written). Here is my code: ?php $host = computer:C:\Servers\interbase\database\employee.gdb; $dbh = ibase_connect ($host, SYSDBA, masterkey); $stmt = select * from

[PHP-DB] Script syntax error

2001-10-05 Thread steve downs
I'm using PHP and MySQL Web Development published by SAM's. I believe the story_submit.php file for the Content Mangement script in Chapter 26 has a syntax problem. I'm getting errors. I'm very new to MySQL PHP and would appreciate some help. The form has a field for uploading an optional .html

[PHP-DB] First? or Last?

2001-10-05 Thread bestbiz4u
Dear Friend, Are you looking for your first Internet business...or your last? If it's your first, I bet you'd like it to be your last! Your last would be the one that allows you to achieve your full time income on a part time basis, is stable, will be there for your heirs, and give you the