[PHP-DB] Pause While-loop when waiting for function call to complete

2011-04-23 Thread listread
While listing each row in a MySQL database, I need to call a function or another php file for each row. How can I make the while-loop wait for the called function to complete before continuing to the next row in the while-loop? Thanks! - Ron -- PHP Database Mailing List (http://www.php.net

Re: [PHP-DB] How to Sync MySQL with iPhone or Google Contacts

2010-10-23 Thread listread
d then notify the changes to your server. I know building an iphone app is a pain, but I think its the right way to do it, if not the only. Is this need for a hobbie or you need to implement this for a public application? Cheers. On 23 October 2010 13:57, listread wrote: Karl / Andrés Than

Re: [PHP-DB] How to Sync MySQL with iPhone or Google Contacts

2010-10-23 Thread listread
the consensus I'm finding on posts about it. HTH Karl On Oct 22, 2010, at 11:21 PM, listread wrote: Hey all! Does anyone know how to go about syncing a MySQL db with an iPhone over the internet? An alternative would be syncing with Google Contacts, which then could sync with the i

[PHP-DB] How to Sync MySQL with iPhone or Google Contacts

2010-10-22 Thread listread
Hey all! Does anyone know how to go about syncing a MySQL db with an iPhone over the internet? An alternative would be syncing with Google Contacts, which then could sync with the iPhone. I think Google Contacts uses Exchange Server to sync with devices. Thanks! - Ron -- PHP Database

Re: [PHP-DB] calling a page for each row

2010-07-15 Thread listread
On 7/15/2010 8:03 PM, Chris wrote: On 16/07/10 09:51, listread wrote: On 7/15/2010 6:42 PM, Chris wrote: On 16/07/10 09:38, listread wrote: We need to load a page which performs some tasks specific to each record, including writing some results to another table. I have tried to place a page

[PHP-DB] calling a page for each row

2010-07-15 Thread listread
We need to load a page which performs some tasks specific to each record, including writing some results to another table. I have tried to place a page loading script within the while loop that creates the table, but it seems to only load the page on the last record in the table. Is there a

Re: [PHP-DB] How to use PHP to fill in existing pdf document

2010-05-01 Thread listread
Yes, I've looked hard at fdpf and see how it is used to generate a new pdf, but I need to simply fill in the form fields in an existing pdf. If it can do that, I'm not finding the feature Thanks, - Ron On 5/1/2010 7:43 PM, Gary wrote: "listread" wrote in messag

Re: [PHP-DB] How to use PHP to fill in existing pdf document

2010-05-01 Thread listread
Yes, we can first ask the user to fill in a form, but then comes the part I don't understand - how to covert it to pdf. It would be best if we could just fill in the fields on an existing form, but it would also work to print the printer friendly form to the server's printer queue, which could

[PHP-DB] How to use PHP to fill in existing pdf document

2010-05-01 Thread listread
Greetings PHP gurus! Does anyone know of a way to use PHP to fill in the form fields in an existing pdf document residing on the server? We want the end result to be the creation of a unique pdf document for each visitor which can either be emailed or stored in a directory on the server. W

Re: [PHP-DB] Building indexes

2010-03-20 Thread listread
This all helps. I think I need to spend some time experimenting. Thanks for your help! - Ron On 3/19/2010 3:56 PM, Bastien Koert wrote: [snip] Here's an example of a tough query (there are lots of Smiths!). SELECT voter1.County, voter1.`First Name`, voter1.`Middle Name`, voter1.`Last N

Re: [PHP-DB] Building indexes

2010-03-19 Thread listread
e hundred thousand queries in the course of validating all the signatures on a petition. Thanks! - Ron listread wrote: Chris, I just assumed that everyone on this list was using MySQL... That's what we're using (v. 5.1.45 GA) with InnoDB as the engine. Most people are but there a

Re: [PHP-DB] Building indexes

2010-03-18 Thread listread
ould reduce the size of the db, but I don't know what that would do to speed... Does any of this affect the approach you would suggest? Thanks!! - Ron On 3/17/2010 11:56 PM, Chris wrote: listread wrote: Greetings! We are working on a 4 million record db with about 55 fields. We n

[PHP-DB] Building indexes

2010-03-17 Thread listread
Greetings! We are working on a 4 million record db with about 55 fields. We need to build indexes to speed queries, but it seems to take way too long. Here are some questions: 1) If a query uses two or three fields is it best to prepare an index with those two or three fields, or will the

Re: [PHP-DB] FW: Oracle Finalizes Acquisition of Sun

2010-01-29 Thread listread
As an open source product, is the code in the public domain? If so, what's to prevent someone(s) from using it as a starting point and creating YourSQL? On 1/28/2010 7:16 PM, Eric Lee wrote: hmm, that' true now !! Shall the mysql db become paid software !! Regards, Eric, On Thu, Jan 28

Re: [PHP-DB] FW: semaphores WAS: [PHP-DB] Automatic logoff

2010-01-29 Thread listread
On 1/28/2010 3:57 PM, Richard Quadling wrote: On 28 January 2010 21:38, Daevid Vincent wrote: An intersting synopsis of "Semaphores". I've done similar things in the past, but never knew this is what I was doing. LOL. Just like I've built an uber XML parser/editor and didn't know that I act

Re: [PHP-DB] Automatic logoff

2010-01-28 Thread listread
Richard, One more question (for now): Are there advantages to using a separate table for locking, rather than specifying a lock column in the table you want to lock the row in? - Ron On 1/28/2010 5:47 AM, Richard Quadling wrote: On 27 January 2010 17:20, listread wrote: Richard, I

Re: [PHP-DB] Automatic logoff

2010-01-28 Thread listread
Great explanation, Richard! I think I understand the concept now. I'll study it a little and try to implement it. Thanks! - Ron On 1/28/2010 5:47 AM, Richard Quadling wrote: On 27 January 2010 17:20, listread wrote: Richard, I think I need to learn about semaphores!

Re: [PHP-DB] Automatic logoff

2010-01-27 Thread listread
Richard, I think I need to learn about semaphores! Any suggestions for a good tutorial? One of the things we want to do is exclude locked records from a query. Will semaphores provide for that? Thanks! - Ron On 1/27/2010 8:14 AM, Richard Quadling wrote: The technique I've used in t

Re: [PHP-DB] Automatic logoff

2010-01-27 Thread listread
otherwise leaves the site. That's why we want a graceful exit. Maybe I should start a new thread about locking db records? - Ron On 1/26/2010 4:03 PM, Chris wrote: listread wrote: Bruno, Thanks for the heads up on the php configuration. I'll check that out. We also need to write so

Re: [PHP-DB] Automatic logoff

2010-01-25 Thread listread
Bruno, Thanks for the heads up on the php configuration. I'll check that out. We also need to write some data to a database, things like logout time. That means running a script for some other php code. Thanks! - Ron On 1/25/2010 1:24 PM, Bruno Fajardo wrote: 2010/1/25 lis

Re: [PHP-DB] Automatic logoff

2010-01-25 Thread listread
js onunload sounds like a viable option. Will it work if the use just closes his browser? Thanks for the tip! - Ron On 1/25/2010 12:51 PM, Bastien Koert wrote: On Mon, Jan 25, 2010 at 1:48 PM, listread wrote: Has anyone considered a way to run a script or automatically access a php

[PHP-DB] Automatic logoff

2010-01-25 Thread listread
Has anyone considered a way to run a script or automatically access a php page when a user leaves a site without logging off? The idea is to gracefully end that user's session. Thanks! -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] How to: Include identifier with a query

2009-11-02 Thread listread
Greetings! We are searching for names that might or might not exist in a 4 million row db and have to do a lot of fuzzy searches that often don't return results. I would like the use to have the option of killing a query process. Since we are apt to have several queries running KILL QUERY d