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

2010-10-23 Thread listread
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 iPhone. I think Google Contacts uses Exchange

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

2010-10-23 Thread listread
: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 iPhone. I think Google Contacts uses Exchange Server to sync with devices

[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

[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] 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] 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.

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

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: listreadlistr...@cze.com wrote in message

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

Re: [PHP-DB] Building indexes

2010-03-19 Thread listread
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 are lots of types of databases out there :) (I just read your tutorial

Re: [PHP-DB] Building indexes

2010-03-18 Thread listread
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 need to build indexes

[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: 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 Vincentdae...@daevid.com 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

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

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, listreadlistr...@cze.com wrote: Richard, I think I need to learn about semaphores!

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, listreadlistr...@cze.com wrote:

Re: [PHP-DB] Automatic logoff

2010-01-27 Thread listread
or 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 some data

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

[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

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, listreadlistr...@cze.com wrote: Has anyone considered a way to run a script or

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

[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