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

2011-10-26 Thread Jason Pruim
Jason Pruim li...@pruimphotography.com On Oct 26, 2011, at 9:09 PM, Jim Giner wrote: > Your boss wants to give access to phone numbers to the public in general? > Then what? > > Glad mine's unlisted. There's no identifying information on the phone numbers... Simply just the phone number...

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

2011-10-26 Thread Jim Giner
Your boss wants to give access to phone numbers to the public in general? Then what? Glad mine's unlisted. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

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

2011-10-26 Thread Jason Pruim
Jason Pruim li...@pruimphotography.com On Oct 26, 2011, at 6:23 AM, Tommy Pham wrote: > On Wed, Oct 26, 2011 at 1:40 AM, Lester Caine wrote: > >> Tommy Pham wrote: >> >>> I wonder ... The real question is what's the purpose of the DB? Is it for >>> OLAP >>> or OLTP? ;) >>> As for dealing w

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

2011-10-26 Thread Tommy Pham
On Wed, Oct 26, 2011 at 4:14 AM, Lester Caine wrote: > Tommy Pham wrote: > >> >>Many of my customers have coming up on 20 years of data available. >> There has >>been a debate on transferring historic data to a separate database, but >>having it available is not causing a problem, exc

[PHP] Re: Displaying variables in text - clarification needed

2011-10-26 Thread Shawn McKenzie
On 10/26/2011 07:20 AM, Rick Dwyer wrote: > Hello all. > > I inherited some PHP pages about a year ago. They have been fine all > along but now a bunch of erroneous errors and results are popping up. I > traced it to the way the variables were being used on the page... for > example, the followi

Re: [PHP] Displaying variables in text - clarification needed

2011-10-26 Thread Lester Caine
Rick Dwyer wrote: Hello all. I inherited some PHP pages about a year ago. They have been fine all along but now a bunch of erroneous errors and results are popping up. I traced it to the way the variables were being used on the page... for example, the following SQL statement (a space between '

[PHP] Displaying variables in text - clarification needed

2011-10-26 Thread Rick Dwyer
Hello all. I inherited some PHP pages about a year ago. They have been fine all along but now a bunch of erroneous errors and results are popping up. I traced it to the way the variables were being used on the page... for example, the following SQL statement (a space between ' and " for

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

2011-10-26 Thread Lester Caine
Tommy Pham wrote: Many of my customers have coming up on 20 years of data available. There has been a debate on transferring historic data to a separate database, but having it available is not causing a problem, except for some counts and larger search actions, and being able to

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

2011-10-26 Thread Tommy Pham
On Wed, Oct 26, 2011 at 3:23 AM, Tommy Pham wrote: > On Wed, Oct 26, 2011 at 1:40 AM, Lester Caine wrote: > >> Tommy Pham wrote: >> >>> I wonder ... The real question is what's the purpose of the DB? Is it >>> for OLAP >>> or OLTP? ;) >>> As for dealing with DB having millions of rows, you're c

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

2011-10-26 Thread Tommy Pham
On Wed, Oct 26, 2011 at 1:40 AM, Lester Caine wrote: > Tommy Pham wrote: > >> I wonder ... The real question is what's the purpose of the DB? Is it for >> OLAP >> or OLTP? ;) >> As for dealing with DB having millions of rows, you're crossing over into >> DBA area. >> > > Many of my customers hav

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

2011-10-26 Thread Lester Caine
Tommy Pham wrote: I wonder ... The real question is what's the purpose of the DB? Is it for OLAP or OLTP? ;) As for dealing with DB having millions of rows, you're crossing over into DBA area. Many of my customers have coming up on 20 years of data available. There has been a debate on trans

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

2011-10-26 Thread Tommy Pham
On Wed, Oct 26, 2011 at 12:52 AM, Lester Caine wrote: > Tommy Pham wrote: > >> 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

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

2011-10-26 Thread Lester Caine
Tommy Pham wrote: 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 the > COUNT was killing the time... Once that was remo