[PHP-DB] Sorting a 2 dimension array

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

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 q

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

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 // To:

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

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

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 f

[PHP-DB] Re: Speeding up database access

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 unsubsc

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

Hello :c) I cant make this work together... I have set up php (it works) I have set up ib (it works) but when i try to query ib using php i get : Fatal error: Call to undefined function: ibase_connect() in c:\inetpub\wwwroot\ib.php on line 10 I have set my extension_dir to (where the dll resid

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

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 dat

[PHP-DB] bitshift

Hello, bit_count(bit_or(1

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

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. Over

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

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 Technolo

[PHP-DB] Re: PHP with Domino Notes

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., Col

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

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

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

Hello, > okay... 1< 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 > will be combined, as there is no difference between

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

- 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 > > ACK! Don't do this. You do know that an unsigned int (using a

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

Hello, > you can always reset the auto_increment value (I think that is as simlple as > "set insert_id=1;" but you may want to double check as this is off the top > of my head). I don't think i can do so cause i never delete all rows. so will get something like: 1 <- new insert her 1000 100

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

Hi, It definitely is not running the dll. Run 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, John - Ori

[PHP-DB] Re: Speeding up database access

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

[PHP-DB] Re: Inserting CSV in MySQL

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

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

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 html

Re: [PHP-DB] array from html form

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

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

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

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

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 messag

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

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 l

[PHP-DB] Propuesta

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, adem

[PHP-DB] Talent Exchange? Need PHP Programmer

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 E

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

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 kn

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

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: email . "\n"; } ibase_close ($dbh); ?> What am i dowing whrong?? Thanks Christian -- PHP Database Mailing List (http://www.php.net/) To un

[PHP-DB] Script syntax error

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 .htm

[PHP-DB] First? or Last?

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