Re: [nyphp-talk] Best way to accomplish this task

2010-02-14 Thread Gary Mort
First off, always process in the smallest increment you can. So don't grab EVERY row, just grab ONE row and process it, then grab the next row and process it... That allows you to run multiple, concurrent processors and each one can grab the data they want. Secondly there are many queing ser

Re: [nyphp-talk] Best way to accomplish this task

2010-02-14 Thread Ajai Khattri
You might find this useful: http://code.flickr.com/blog/2008/09/ -- Aj. ___ New York PHP Users Group Community Talk Mailing List http://lists.nyphp.org/mailman/listinfo/talk http://www.nyphp.org/Show-Participation

Re: [nyphp-talk] Best way to accomplish this task

2010-02-14 Thread Justin Dearing
You might want to look at a queuing system to hold the input. Your options are Microsoft message queuring apache mq and IBM tibco. I am sure there are others Microsoft message queue is supported by php and built into windows. apache probably is. Tibco is expensive. They all will solve your probl

Re: [nyphp-talk] Best way to accomplish this task

2010-02-14 Thread Michele Waldman
Anthony, I'd have to actually look, but you may be able to kick the process off with a system command and grab the process id at the same time. Or kick the process off with some unique id that will help you grab the exact process id after the fact. One of the other guys, may have a more pract

Re: [nyphp-talk] Best way to accomplish this task

2010-02-14 Thread Michele Waldman
Anthony, I'd actually have to put some real thought into it. I'm watching tv. But, I think a timestamp would actually be ugly. Some random id doesn't really tell you anything. When I work with shell scripts, I actually capture the process id. Then if the records are unprocessed and the p

Re: [nyphp-talk] Best way to accomplish this task

2010-02-14 Thread Anthony Papillion
Andy, Thanks for the input. I'm going to look into that too. Sounds reasonable and takes care of a few problems that popped up in my head. Thanks, Anthony - Original Message - From: "Andy Dirnberger" To: "NYPHP Talk" Sent: Sunday, February 14, 2010 7:56 PM Subject: Re: [nyphp-talk

Re: [nyphp-talk] Best way to accomplish this task

2010-02-14 Thread Anthony Papillion
Michele, Thank you for your input. I'm glad I seem to be on the right track here and I'm curious about what others might think of this method of walking the database too. I hadn't thought about the additional logic part in the event of an error. How would you propose that be handled? Perhaps a

Re: [nyphp-talk] Best way to accomplish this task

2010-02-14 Thread Andy Dirnberger
On Sun, Feb 14, 2010 at 8:49 PM, Anthony Papillion wrote: > > Hello Everyone, > > I'm designing a system that will work on a schedule. Users will submit data > for processing into the database and then, every minute, a PHP script will > pass through the db looking for unprocessed rows (marked pe

Re: [nyphp-talk] Best way to accomplish this task

2010-02-14 Thread Michele Waldman
As I was reading, I was thinking that would be my approach. I'm not seeing anything ugly about it. Records being processed should have a status as such. You might have some additional logic, that picks up records in the event one of the processes fail for some reason. Sever goes down or some

[nyphp-talk] Best way to accomplish this task

2010-02-14 Thread Anthony Papillion
Hello Everyone, I'm designing a system that will work on a schedule. Users will submit data for processing into the database and then, every minute, a PHP script will pass through the db looking for unprocessed rows (marked pending) and process them. The problem is, I may eventually have a few

Re: [nyphp-talk] tabs disappearing after mail function

2010-02-14 Thread Michele Waldman
Your problem is line 92. exit(); I'm not doing anymore. You'll receive an invoice. :-) Michele _ From: talk-boun...@lists.nyphp.org [mailto:talk-boun...@lists.nyphp.org] On Behalf Of selyah Sent: Sunday, February 14, 2010 4:56 PM To: NYPHP Talk Subject: Re: [nyphp-talk] tabs dis

Re: [nyphp-talk] tabs disappearing after mail function

2010-02-14 Thread Michele Waldman
I'd leave it on til I go live. Michele > -Original Message- > From: talk-boun...@lists.nyphp.org > [mailto:talk-boun...@lists.nyphp.org] On Behalf Of David Krings > Sent: Sunday, February 14, 2010 5:07 PM > To: NYPHP Talk > Subject: Re: [nyphp-talk] tabs disappearing after mail functio

Re: [nyphp-talk] tabs disappearing after mail function

2010-02-14 Thread Michele Waldman
Don't forget to reboot or set the flag in the module. Michele _ From: talk-boun...@lists.nyphp.org [mailto:talk-boun...@lists.nyphp.org] On Behalf Of selyah Sent: Sunday, February 14, 2010 4:43 PM To: NYPHP Talk Subject: Re: [nyphp-talk] tabs disappearing after mail function i have

Re: [nyphp-talk] tabs disappearing after mail function

2010-02-14 Thread David Krings
On 2/14/2010 4:43 PM, selyah wrote: i have display_errors off...i will try it with that on and see what happens. do you or any one know of any issues with firefox version 3.5 and php? No, and the browser doesn't matter. You know, PHP is a server side scripting language And yea, turn displ

Re: [nyphp-talk] tabs disappearing after mail function

2010-02-14 Thread selyah
michele: I am attaching the page for you ian From: Michele Waldman To: NYPHP Talk Sent: Sun, February 14, 2010 2:54:00 PM Subject: Re: [nyphp-talk] tabs disappearing after mail function Hum. Bug somewhere. Lol Why don’t you test it out using anot

Re: [nyphp-talk] tabs disappearing after mail function

2010-02-14 Thread selyah
i have display_errors off...i will try it with that on and see what happens. do you or any one know of any issues with firefox version 3.5 and php? From: Michele Waldman To: NYPHP Talk Sent: Sun, February 14, 2010 2:54:00 PM Subject: Re: [nyphp-talk] tabs

Re: [nyphp-talk] tabs disappearing after mail function

2010-02-14 Thread Michele Waldman
Hum. Bug somewhere. Lol Why don't you test it out using another php module, even one doing next to nothing. I know echos and prints can really skew a layout. A bug in the php will halt any rendering below the include, but I haven't seen the code, so . First, I'd try to identify wh

Re: [nyphp-talk] tabs disappearing after mail function

2010-02-14 Thread David Krings
On 2/14/2010 3:43 PM, selyah wrote: Hello: I have an issue. first let me layout my site which is testing mode. I am having problem with the php page that handles the form information. the pages blocks are controlled by statements, no tables. there is a block on the top for the logo, below that i

[nyphp-talk] tabs disappearing after mail function

2010-02-14 Thread selyah
Hello: I have an issue. first let me layout my site which is testing mode. I am having problem with the php page that handles the form information. the pages blocks are controlled by statements, no tables. there is a block on the top for the logo, below that is the content block, and to the