RE: [PHP-DB] Help!!!

In the second loop you do an array_shift($entry) which should be array_shift($all). Perhaps a foreach loop would be easier: Jos -Original Message- From: NIPP, SCOTT V (SBCSI) [mailto:[EMAIL PROTECTED] Sent: 18 May 2005 22:47 To: php-db@lists.php.net Subject: [PHP-DB] Help!!!

[PHP-DB] FormBuilder linkNewValue issue

Hello, I'm posting here since I cannot find a proper list for FormBuilder. I have a big problem here: * I have a FB form with one linkNewValue linked table (PK on linked table points to FK on main table) * When there is an error in the main form, the linked new value in sub-form is inserted co

RE: [PHP-DB] Multiselect List

That's not the problem. The problem is referring to the listbox via javascript. It doesn't like the format: formName.listBoxName[].value it has no problem with formName.listBoxName.value but then PHP doesn't seem to handle it correctly. <>< Ryan From: Dimiter Iv

Re: [PHP-DB] Multiselect List

Ryan, you've had a couple of solutions that will work. The macromedia function, and the direct reference to the element - document.formName.elements['listBoxName[]']. For me the direct reference to the element is the most simple, and you can access the properties in the normal way e.g. do

[PHP-DB] Limiting Results

I am trying to limit results pulled from two tables, each with all states and congressional districts, to specified congressional districts. I want each college to appear once matched to each congressional district (that is in one table and is easy to do) and also include a column from a sec

[PHP-DB] Problems with interbase extension

Hello, I'm maintainer of databases/firebird port on FreeBSD, and I've splitted this port in two ports, firebird-client and firebird-server. To install php with interbase extension, the only dependency is firebird-client, and all builds fine, but, when I try to runa ibase_pconnect, the proccess st

[PHP-DB] Moving data from one MySQL table to another

I'm working on a web application and one of the things I am doing is creating an archiving function that would move older data to archive tables in order to minimise the amount of data in the active tables. This so that the data that is being used more frequently can be accessed faster by the

Re: [PHP-DB] Limiting Results

You could always try the LIMIT keyword :) select a.college, a.state, a.cd , b.rep from a, b where a.state = "al" and a.cd = "3" or a.state = "az" and a.cd = "1" and a.state = b.state and a.cd = b.cd LIMIT 50 -- Joseph

[PHP-DB] adodb is slow

hi all, I'm proud to install adodb library in my framework. I succesfully got it. But, surprise! My scripts became slower than ever! Exactly the 33% of the time is spent by adodb So, I know the advantages of this library, and I understand the reason is so slow...but, well, I wondered if somebody ha

RE: [PHP-DB] Limiting Results

I believe you need a main table where youn list all the colleges with columns for STATE, CONGRESSIONAL DISTRICT and REPRESENTATIVE. And those three columns would be pulled from three table catalogs: STATES, CONGRESSIONAL DISTRICTS and REPRESENTATIVES. Maybe there is a better approach, but I don't

RE: [PHP-DB] Moving data from one MySQL table to another

if the archive tables structures are identical and no processing needs to be done, why not use a 'select into table where ' and use the ids of the records to choose the ones that move? Bastien From: Jeffrey <[EMAIL PROTECTED]> To: php-db@lists.php.net Subject: [PHP-DB] Moving data from one MySQL

[PHP-DB] Re: Problems with interbase extension

On 19/05/05, Renato Botelho <[EMAIL PROTECTED]> wrote: > Hello, > > I'm maintainer of databases/firebird port on FreeBSD, and I've > splitted this port in two ports, firebird-client and firebird-server. > > To install php with interbase extension, the only dependency is > firebird-client, and all

Re: [PHP-DB] Moving data from one MySQL table to another

Try do that whit phpmyadmin. Regards, Luis Morales Bastien Koert wrote: > if the archive tables structures are identical and no processing needs > to be done, why not use a 'select into table where ' and use the ids > of the records to choose the ones that move? > > Bastien > >> From: Jeffrey

[PHP-DB] More problems with a script. How to I get to a next entry

HI All, I have this script. (See below) it was designed to allow my case managers to look at a list of the case noted they have generated on a specific client. It allows the case manager to select the client and then it shows them the case note. Only problem is that it only shows them one case

RE: [PHP-DB] More problems with a script. How to I get to a next entry

you need to adjust the sql to remove some of the limiters in the where clause. ie remove the dates. Just join on the ids that should get you what you need... Bastien From: "John R. Sims, Jr." <[EMAIL PROTECTED]> To: , Subject: [PHP-DB] More problems with a script. How to I get to a next entry

[PHP-DB] Need help with a tricky query

I'm trying to write a query that pulls details on a game record, as well as the officials assigned to the game (up to 4 officials may be assigned to each game, but that's not always the case). Game details are in the games table, and assignments are in the games_referees table (which I alias as re