Re: [PHP-DB] PHP sort from .... best solution?

Hi again! I talked to the admin guy and he said there is an easyer way to do this (as usual he doenst have the time to show me) so I try here: He gave me a liddle example in c and a light translation to PHP: Bubble sort (exampel written in c, but can "easyly" be translated to php): for (i=0; ih

Re: [PHP-DB] PHP sort from a database variable..?

wow! thats a much more elegant way to solve this sorting problem! didn't know usort up to now! simple&beautiful !! :) .ma Ford, Mike [LSS] <[EMAIL PROTECTED]> [EMAIL PROTECTED] 11:18 Uhr: >> -Original Message- >> From: heilo [mailto:[EMAIL PROTECTED] >> Sent: 03 June 2003

RE: [PHP-DB] I have a problem to add a new line to the body of my email when I am using '

I believe the body is supported. I have read everything I could find through Google. People are using it exactly as I am. I can't use '\n' - it is only text in this case and it will be part of the email body. Thanks anyway, Martin -Original Message- From: John W. Holmes [mailto:[EMAIL PR

RE: [PHP-DB] I have a problem to add a new line to the body of my email when I am using '

> I have a problem to add a new line to the body of my email when I am using > ' > This is my code: > > $details[email] //email of the user from the form > $details[contact_name] //name of the user from the form > > $email_subject = "subject text..."; > > $email_form = "Welcome ".$details[conta

[PHP-DB] I have a problem to add a new line to the body of my email when I am using '

Hi, I have a problem to add a new line to the body of my email when I am using 'Send the email I am not sending the email with details from a form automatically because of a request of my client that wants to be able to add an additional text for a user if needed. What is strange. I have tried i

RE: [PHP-DB] PHP sort from a database variable..?

> -Original Message- > From: heilo [mailto:[EMAIL PROTECTED] > Sent: 03 June 2003 23:35 > > sorry, needed some time to hack this one ::) > > as your print_r shows that you have to sort an array which > includes objects > (in this case an ingress-class - whatever this is). i tried > to s

RE: [PHP-DB] Array Pointer

> -Original Message- > From: Ian Fingold [mailto:[EMAIL PROTECTED] > Sent: 03 June 2003 16:58 > > Ok I'm trying to write this function to up date some fields > in my database > so i'm grabbing some info from a query and throwing it into > an array (with > mysql_fetch_array). > > one of

[PHP-DB] Re: Help with oci dll in PHP

> Warning: ocilogon > (): _oci_open_server: Error while trying to retrieve > text for error ORA-12538 in c:\inetpub\wwwroot\php\index.php on line 15 ORA-12538 means "TNS : no such protocol" - you have a problem in your TCP protocol ? - or there is a typo error in your line : > $db = " (DESCRIPTI

[PHP-DB] Help with oci dll in PHP

A guy, Filippov Evgeny, mails directly to me with the following question. I answer in this group, to share the problem and the solution. Philippe S. From: evgeny Hi! Excuse please, I have seen your answers and has decided(solved) t

Re: [PHP-DB] strip

Thanks a lot frank, It's working nicely :o) "Frank M. Kromann" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > > That depends on your backend. Some database systems uses \ to escape ' > others uses '. In the last case use > > $value = str_replace("'", "''", $value); > > - Frank > >

Re: [PHP-DB] database model

I have been using Dezign for Databases from Datanamic for several years. http://www.datanamic.com/ Not free, but invaluably helpful. I strongly recommend it. Ignatius - Original Message - From: "Snijders, Mark" <[EMAIL PROTECTED]> To: <[EMAIL P

[PHP-DB] runing local programs with php

Hy all, How can I run program on a client machine using a php script. For example paint or acces. which are runing on client machine. TKS

Re: [PHP-DB] MSSQL Optimize?

Mssql server has a list of tools you can use for this. When you create the database (or later modify it through Enterprice Manager) you can specify 'Auto Shrink'. This will make sure the file sise is optimized when you delete data. This cal also be done with this call: sp_dboption('database', 'au

Re: [PHP-DB] strip

That depends on your backend. Some database systems uses \ to escape ' others uses '. In the last case use $value = str_replace("'", "''", $value); - Frank > Don't. addslashes() instead. > > Chris Mach wrote: > > >does anyone know how to strip a ' from a string? It's causing errors for my >

[PHP-DB] MSSQL Optimize?

Please forgive me for being somewhat off topic. This information is going towards a db class written in php. Does MSSQL have an SQL command counterpart to mysql's Optimize or postgresql's Vacuum?? Thanks for any insight you may provide... -- PHP Database Mailing List (http://www.php.net/) To unsu

[PHP-DB] PEAR DB and PostgreSQL on dual processor Mac OS X

Hello, I have a data warehouse application I've built with PHP 4.3 and PostgreSQL 7.3.2 running on Mac OS X 10.2.6 on a dual 1.42 Ghz G4. I've noticed a performance issue with my application when using PEAR DB 1.4. If I launch a complex select query (PHP page) from 3 different browser windows,

Re: [PHP-DB] strip

Don't. addslashes() instead. Chris Mach wrote: does anyone know how to strip a ' from a string? It's causing errors for my sql statements -- The above message is encrypted with double rot13 encoding. Any unauthorized attempt to decrypt it will be prosecuted to the full extent of the law.

[PHP-DB] strip

does anyone know how to strip a ' from a string? It's causing errors for my sql statements -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] problem

Ahmed, You didn't say if you are using POST or GET for the form or the version of PHP that you are using. Please email us the version of PHP and the HTML for the form that you are using if the suggestions below don't work. But basically, the problem is that the data from the form are elements in

[PHP-DB] RE: [PHP-DB] Reserve Username while Confirming Signup

Alright thanks. Can I put a crontab on the script? But I'm not really familiar with the crontab thing. I'm using a hosting, it's Linux with Apache. I saw some articles in php.net on using crontab but it looks alien to me. Thanks a lot everyone! Dewi _

[PHP-DB] problem

hi again, i use php/mysql and i have a form to enter data into tables insiede the database the problem is when i click the submit botton it gives me that 1 row is affected and when i check the database with phpmyadmin i find that all the data processed

Re: [PHP-DB] PHP sort from .... best solution?

no prob i think its not the best solution, because its a workaround the core-problem. as i said it would be better to access the data directly and without any functions or complicated classes. this structure is for very complex systems whose code may change very often. so the highest standard of s

Re: [PHP-DB] PHP sort from a database variable..?

It worked. Thanx! Why is this a bad solution? Will it slow down the feed? Regards, A. Lyse -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] PHP sort from a database variable..?

i think this one should now work. remember that this is no very proper solution! it would be better not to work with such functions and access the database directly i think. .ma artikkelid = $artikkelid; $this->nettstedid = $nettstedid; $db = new pubSysDB(); /* K

Re: [PHP-DB] PHP sort from a database variable..?

Almoust now! Got some (alot of errors) but it sorts correct: (see the errors here) http://www.amotor.no/artikler.php Here is altso the PubSysDB: http://www.amotor.no/pubSysDB.lib Regards, A. Lyse -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/uns

[PHP-DB] Shopping Cart Updating Quantities Question.

Greetings all, Ok, I've made some progress with my shopping cart. I can now update the quantity of one item only. When I try to update the quantities of 2 products it only lists the first product with its previous quantity. I also need to press the "update quantity" button twice for the quantity

Re: [PHP-DB] PHP sort from a database variable..?

ok, add the following lines to your ingress.lib-file: /***/ // converts any array to an instance of the ingress-class function array2IngressClass($array) { $inst = new ingress(); while(list($key, $val) = each($array)) $inst->$key = $val;

Re: [PHP-DB] PHP sort from a database variable..?

Here is the php file *** '.$i->overskrift.'   ('.$i->publisert.') '.$i->ingress.' ' ; } } ?> -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] PHP sort from a database variable..?

This might helt some: The php file: http://www.amotor.no/list_ingresser_artikler.php The ingress.lib file: http://www.amotor.no/ingress.lib The comments might be a bit weird. Its norwegian :( Regards, A. Lyse -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://w

Re: [PHP-DB] PHP sort from a database variable..?

did you also copy the functions? A. Lyse <[EMAIL PROTECTED]> [EMAIL PROTECTED] 0:40 Uhr: > I get this error: > > Fatal error: Call to undefined function: sortclassarray() in > /home/amotor/www/list_ingresser_artikler.php on line 25 > > Regards, > A. Lyse > > -- PHP Database Mailing List (ht

Re: [PHP-DB] PHP sort from a database variable..?

I get this error: Fatal error: Call to undefined function: sortclassarray() in /home/amotor/www/list_ingresser_artikler.php on line 25 Regards, A. Lyse -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] PHP sort from a database variable..?

sorry, needed some time to hack this one ::) as your print_r shows that you have to sort an array which includes objects (in this case an ingress-class - whatever this is). i tried to simulate your environement and endet up with this: function array2IngressClass($array) { $inst =

Re: [PHP-DB] PHP sort from a database variable..?

Hope I did this correctly now :) It is a new, "home made" news - system, only I want some new functions to it. I must make the functions myself then :( Here is the info: Array ( [0] => ingress Object ( [artikkelid] => 241 [nettstedid] => 11 [gyldig]

Re: [PHP-DB] PHP sort from a database variable..?

hi! we need information about how the array looks like! please add the following to your script (after merging $i1 and $i2): echo ''; print_r($ingresser); echo ''; and send the resulting output! you can use array_multisort for this problem. anyways i propose to write your own news-tool. sorting

[PHP-DB] PHP sort from a database variable..?

Please dont kill me for posting here. I dont know where else to post. I'm a newbie and is completly stuck with a php problem :( I got this code (among with more though...): *** $i1=hentIngresser($nettstedid,38,$sprakid,$offsetannet,$antallmotor); $i2=hentIngresser($nettstedid,

[PHP-DB] Test

Sorry about the test, but . . .

[PHP-DB] Array Pointer

Ok I'm trying to write this function to up date some fields in my database so i'm grabbing some info from a query and throwing it into an array (with mysql_fetch_array). one of the values i'm puting into that array is the table id. I'm then comparing the table id with the value of $i in my loop. N

RE: [PHP-DB] problem with undefined variable

sorry, had written first_var instead of first_rec for some reason, should make more sense now! register_globals must be turned on on your webserver and off on your local server, you are getting the new value for first_rec from the GET array registering first_rec as a global. Same thing for the

RE: [PHP-DB] problem with undefined variable

register_globals must be turned on on your webserver and off on your local server, you are getting the new value for first rec from the GET array registering first_var as a global. Same thing for the PHP_SELF error. So change this you need to get the value of $first_var like $first_var=$_GET['f

[PHP-DB] problem with undefined variable

hi again, i use php/mysql with ISS server on windows xp professional i have a script that works well on the web to view only 50 records per page, but when i use it on my local server i get this error in the page and it views the same 1st 50 records the message in the page is "Notice: Undefined va

Re: [PHP-DB] Query takes to much time

What database are you using? Also, are all the fields involved in the joins and whare clause properly indexed? Depending on the database you are using, it is possible to determine if the indexed fields are being used. -- bob On Tue, 3 Jun 2003, André Sannerholt wrote: > Hi everybody, > > now I

[PHP-DB] Query takes to much time

Hi everybody, now I have the following qery that still needs to much time: select distinct Anschriften.ID as aid, Anschriften.PLZ as aplz, Anschriften.STRASSE as astrasse, Anschriften.HNR as ahnr from Anschriften inner join Master on Anschriften.ID=Master.A inner join Master as m on Master.FN=m.F