php-general Digest 25 Oct 2011 12:25:34 -0000 Issue 7536

2011-10-25 Thread php-general-digest-help
php-general Digest 25 Oct 2011 12:25:34 - Issue 7536 Topics (messages 315402 through 315418): Exporting large data from mysql to html using php 315402 by: Jason Pruim 315404 by: Shiplu Mokaddim 315405 by: Bastien 315409 by: Jim Giner 315410 by:

php-general Digest 26 Oct 2011 01:43:16 -0000 Issue 7537

2011-10-25 Thread php-general-digest-help
php-general Digest 26 Oct 2011 01:43:16 - Issue 7537 Topics (messages 315419 through 315426): Re: Geo IP Location help needed... 315419 by: Daniel Brown Re: Exporting large data from mysql to html using php 315420 by: Jim Giner 315422 by: Jason Pruim 315423

Re: Re: [PHP] Geo IP Location help needed...

2011-10-25 Thread Tim Streater
On 25 Oct 2011 at 02:36, DealTek deal...@gmail.com wrote: On Oct 24, 2011, at 6:23 PM, Bastien wrote: On 2011-10-24, at 9:07 PM, DealTek deal...@gmail.com wrote: If the IP is showing, could there be some left over debug in some function? If the IP is not in your list it could be anything

Re: [PHP] Geo IP Location help needed...

2011-10-25 Thread Daniel Brown
On Mon, Oct 24, 2011 at 21:07, DealTek deal...@gmail.com wrote: Q: Is there some code that can ALWAYS tell the country name of the IP? More often than not, you will get accurate, real-time (as in, not static and potentially stale from a database) results using a direct WHOIS query. If

Re: [PHP] Exporting large data from mysql to html using php

2011-10-25 Thread Jim Giner
I disagree. It's not about tuning the queries, it is more about the appl. design that currently thinks it SHOULD do such huge queries. My approach would be to prompt the user for filtering criteria that automatically would reduce the result set size. Although at this time I believe the OP

Re: [PHP] Friday Distraction

2011-10-25 Thread Tedd Sperling
On Oct 23, 2011, at 9:38 PM, tamouse mailing lists wrote: http://reflectionbeads.com/i/design-your-own That's a very interesting site. Surprising that it doesn't use a lick of PHP to do what it's doing, given what you wrote below. How do you know that? Just to be argumentative, the entire

Re: [PHP] Exporting large data from mysql to html using php

2011-10-25 Thread Jason Pruim
Jason Pruim li...@pruimphotography.com On Oct 25, 2011, at 10:51 AM, Jim Giner wrote: I disagree. It's not about tuning the queries, it is more about the appl. design that currently thinks it SHOULD do such huge queries. My approach would be to prompt the user for filtering criteria

Re: [PHP] Exporting large data from mysql to html using php

2011-10-25 Thread Jim Giner
Again why even do a detail query? Nobody is going to examine pages and pages and etc. Do a summary qry if u just need a count - no pagination there jg On Oct 25, 2011, at 6:26 PM, Jason Pruim li...@pruimphotography.com wrote: Jason Pruim li...@pruimphotography.com On Oct 25,

Re: [PHP] Exporting large data from mysql to html using php

2011-10-25 Thread Jason Pruim
Jason Pruim li...@pruimphotography.com On Oct 25, 2011, at 6:35 PM, Jim Giner wrote: Again why even do a detail query? Nobody is going to examine pages and pages and etc. Do a summary qry if u just need a count - no pagination there jg The bosses wanted them to be able to page

Re: [PHP] Exporting large data from mysql to html using php

2011-10-25 Thread Bastien
On 2011-10-25, at 6:56 PM, Jason Pruim li...@pruimphotography.com wrote: Jason Pruim li...@pruimphotography.com On Oct 25, 2011, at 6:35 PM, Jim Giner wrote: Again why even do a detail query? Nobody is going to examine pages and pages and etc. Do a summary qry if u just

Re: [PHP] Exporting large data from mysql to html using php

2011-10-25 Thread Jim Giner
David Robley robl...@aapt.net.au wrote in message news:49.50.34068.1b567...@pb1.pair.com... Consider running EXPLAIN on all your queries to see if there is something Mysql thinks could be done to improve performance. Why do so many responders seem to think the problem here is in the

Re: [PHP] Exporting large data from mysql to html using php

2011-10-25 Thread David Robley
Jason Pruim wrote: Jason Pruim li...@pruimphotography.com On Oct 25, 2011, at 10:51 AM, Jim Giner wrote: I disagree. It's not about tuning the queries, it is more about the appl. design that currently thinks it SHOULD do such huge queries. My approach would be to prompt the

Re: [PHP] Exporting large data from mysql to html using php

2011-10-25 Thread Jason Pruim
Jason Pruim li...@pruimphotography.com On Oct 25, 2011, at 9:58 PM, Jim Giner wrote: David Robley robl...@aapt.net.au wrote in message news:49.50.34068.1b567...@pb1.pair.com... Consider running EXPLAIN on all your queries to see if there is something Mysql thinks could be done to

Re: [PHP] Exporting large data from mysql to html using php

2011-10-25 Thread Jim Giner
- Original Message - From: Jason Pruim li...@pruimphotography.com To: Jim Giner jim.gi...@albanyhandball.com Cc: php-general@lists.php.net Sent: Tuesday, October 25, 2011 10:06 PM Subject: Re: [PHP] Exporting large data from mysql to html using php It turns out the issue was actually

Re: [PHP] Exporting large data from mysql to html using php

2011-10-25 Thread Jason Pruim
Jason Pruim li...@pruimphotography.com On Oct 25, 2011, at 10:10 PM, Jim Giner wrote: - Original Message - From: Jason Pruim li...@pruimphotography.com To: Jim Giner jim.gi...@albanyhandball.com Cc: php-general@lists.php.net Sent: Tuesday, October 25, 2011 10:06 PM Subject: Re:

Re: [PHP] Exporting large data from mysql to html using php

2011-10-25 Thread Tommy Pham
On Tue, Oct 25, 2011 at 7:06 PM, Jason Pruim li...@pruimphotography.comwrote: It turns out the issue was actually in the pagination... I'm reworking the whole thing and stream lining it... But in the pagination that I found on the internet it used a SELECT COUNT(*) WHERE state='{$state}'; and