[PHP-DB] Looping advice sought

2002-01-22 Thread George Pitcher
Hi all, I am about to start on a script page which will loop thru a MySQL table and update records depending on the actions of the user. I propose to loop through, row by row performing a separate UPDATE statement for each row, unless someone can advise me of a better way (2d array?). I am

Re: [PHP-DB] Looping advice sought

2002-01-22 Thread Miles Thompson
Good morning George, As always, it depends on the data. Knowing how large your queriesare, can you give us a stripped down example of two iterations? Not code, just an example of what you're wanting to update or insert. Miles At 11:24 AM 1/22/2002 +, George Pitcher wrote: Hi all, I am

[PHP-DB] Re: Looping advice sought

2002-01-22 Thread George Pitcher
Miles, It's not as bad as some of my queries. Here's my code so far: = = = = = = $i=1; while $i($howmany + 1) { $activity=($activity . $i); $tr_id=($tr_id . $i); if($activity'' and $activity'Delete' and $activity'Submit'){ if($activity=='Decline') $activity='Declined';

Re: [PHP-DB] Looping advice sought

2002-01-22 Thread DL Neil
George, I am about to start on a script page which will loop thru a MySQL table and update records depending on the actions of the user. I propose to loop through, row by row performing a separate UPDATE statement for each row, unless someone can advise me of a better way (2d array?). It

Re: [PHP-DB] Re: Looping advice sought

2002-01-22 Thread DL Neil
George, Please check out 6.4.5 UPDATE Syntax! Rather than a complex series of partly nested IF statements, can you rationalise the structure to a SWITCH-CASE? - and with neater (than email) formatting improve readability/comprehension as well? $i=1; while $i($howmany + 1) {

[PHP-DB] Problems using Interbase

2002-01-22 Thread Guy Boanas
Hello - I appreciate any help that others are able to give on this. I'm running the following development environment - - NTWS 4, SP6 - Apache 1.3.22 - PHP 4.1.1 - Interbase 6 (have tried both Borland and Firebird builds) phpinfo() shows that the interbase module (build 1.68.2.2) is

[PHP-DB] MSSQL

2002-01-22 Thread Cesar Schneider
I'm using PHP with PostgreSQL and now I need to use MSSQL... what modifications I need to do !? I already get php_mssql.dll and put it on /etc/php4/apache... is it right !? thanks César -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional

Re: [PHP-DB] Looping advice sought

2002-01-22 Thread George Pitcher
Miles, It's not as bad as some of my queries. Here's my code so far: = = = = = = $i=1; while $i($howmany + 1) { $activity=($activity . $i); $tr_id=($tr_id . $i); if($activity'' and $activity'Delete' and $activity'Submit'){ if($activity=='Decline') $activity='Declined';

RE: [PHP-DB] iODBC module for PHP on linux

2002-01-22 Thread Andrew Hill
Thomas, You can use the HOWTO at www.iodbc.org for assistance in recompiling PHP --with-iodbc. Best regards, Andrew Hill Director of Technology Evangelism OpenLink Software http://www.openlinksw.com Universal Data Access Data Integration Technology Providers -Original Message-

[PHP-DB] RE: [PEAR-DEV] New Metabase Aniversary release

2002-01-22 Thread Lukas Smith
Hi, so for all who care: I will begin pearifying Metabase starting next week. Obviously this will take a fair amount of time. Also I am fairly busy with work so any help is greatly appreciated. This is also my first stab at reworking such a huge amount of code that was originally written by

[PHP-DB] PING Check

2002-01-22 Thread Rick Emery
I'm developing a PHP/MySQL site for a client. He already has a web-host for another domain and would like to re-direct the new domain to a sub-directory within the allotted space of the previous domain. To perform that re-direct, I just started using EVERYDNS.NET. The Problem: when I attempt

[PHP-DB] Help with MySQL SELECT loop

2002-01-22 Thread Kenneth Brill
The code below is my first attempt at a multiple SELECT. Is there a better way? Thanks Ken Brill [EMAIL PROTECTED] function TotalCountSongs($channel) { // create a temp table to fill a.. $sql = CREATE

RE: [PHP-DB] HTTP authentication

2002-01-22 Thread Mikusch, Rita
I had the same problem . . . couldn't get HTTP authentication to work. It turn out that I had to email my ISP and ask their sysadmin to set the HTTP authentication to work individually for each directory I needed it for. I can't remember the apache details -- they needed to add a line to some

FW: [PHP-DB] theme header query

2002-01-22 Thread Rick Emery
I agree, the code is easier to read if each instruction is placed on a separate line (See below) Anyway, I notice that your first statement appears to be a fragment of a string assignment- please post the entire line. Your last line appears to have the same problems. Please re-post your

[PHP-DB] Re: [metabase-dev] RE: [PEAR-DEV] New Metabase Aniversary release

2002-01-22 Thread Manuel Lemos
Hello Lukas, Lukas Smith wrote: I also would like to hear if anyone uses Metabase with using the API in metabase_interface.php .. if there are not many people using it then all then I can safely modify the method names and parameters orders in the new DB class and make the same changes to

[PHP-DB] Re: [PEAR-DEV] Re: [metabase-dev] RE: [PEAR-DEV] New Metabase Aniversary release

2002-01-22 Thread Björn Schotte
* Manuel Lemos wrote: I think that the greatest point of the merger is to have one and only one abstraction layer in PEAR, I think consensus was that there shouldn't be the one and only XYZ PEAR class but more than one XYZ PEAR class (like IT[X] and the PEAR rewrite of PHPLib's Template

[PHP-DB] Re: [binarycloud-dev] Re: [PEAR-DEV] New Metabase Aniversaryrelease

2002-01-22 Thread Alex Black
I will first focus on the functional aspects, then step by step making the necessary changes to make that final code compliant to the PEAR coding standard. This makes no sense for PEAR. I propose this way: 1. pearize Metabase (functionNames, using PEAR_Error) 2. commit the stuff to PEAR

[PHP-DB] Re: [binarycloud-dev] Re: [PEAR-DEV] Re: [metabase-dev] RE:[PEAR-DEV] New Metabase Aniversary release

2002-01-22 Thread Alex Black
* Manuel Lemos wrote: I think that the greatest point of the merger is to have one and only one abstraction layer in PEAR, I think consensus was that there shouldn't be the one and only XYZ PEAR class but more than one XYZ PEAR class (like IT[X] and the PEAR rewrite of PHPLib's Template

[PHP-DB] Re: [binarycloud-dev] Re: [PEAR-DEV] Re: [metabase-dev] RE: [PEAR-DEV] New Metabase Aniversary release

2002-01-22 Thread Björn Schotte
Hi Alex, * Alex Black wrote: The database abstraction layer's behavior and capabilities dictate application development and we sure as hell don't want 5 abstraction layers with the same API floating around. Why not? People can choose if they want to use PEAR::Metabase or PEAR::DB or PHPLIB's