Re: [PHP] set_error_handler() only triggering every Nth time

2012-03-22 Thread Robert Cummings
On 12-03-22 03:57 PM, Daevid Vincent wrote: Resending since I didn't get a single reply. Maybe it got lost? -Original Message- Sent: Tuesday, March 13, 2012 5:58 PM I am implementing a custom error handler and started noticing some bizarre behavior. Every Nth time I refresh the page, I

Re: [PHP] Thinking out loud - a continuation...

2012-03-22 Thread Robert Cummings
On 12-03-22 03:54 PM, Jay Blanchard wrote: [snip] At one point you indicated all the data was coming from one table. Can you send me the table fields and indicate which fields are used to determine parent child relationship? Also 2 sample rows of data which have a relationship would be helpfu

[PHP]make error

2012-03-22 Thread 黄昭源
Hello, I have a problem. When I configure php with the parameter --with-mysql=/usr/local/mysql and make, some errors happen. Below is the errors: ext/mysql/php_mysql.c:995: undefined reference to `_mysqlnd_init' ext/mysql/php_mysql.c:1012: undefined reference to `mysqlnd_connect' ext/mysql/php_mysq

Re: [PHP] MySQL table design

2012-03-22 Thread Jim Giner
Leave the past behind. You're moving forward. And - for whatever reason that they were used originally, you now have the opportunity to rid yourself of column names that must be a pia to type all the time. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.

Re: [PHP] MySQL table design

2012-03-22 Thread Chris Stinemetz
On Thu, Mar 22, 2012 at 7:42 PM, Stuart Dallas wrote: > On 23 Mar 2012, at 00:10, Chris Stinemetz wrote: > >> Is it possible to create a MySQL table with characters such as "." and >> "[]" in the column headers? If so would you explain how? > > Try putting the column names in backticks (`). > > BU

Re: [PHP] MySQL table design

2012-03-22 Thread Bastien
On 2012-03-22, at 8:10 PM, Chris Stinemetz wrote: > Hello List, > > Is it possible to create a MySQL table with characters such as "." and > "[]" in the column headers? If so would you explain how? > > Thank you, > > Chris > > -- > PHP General Mailing List (http://www.php.net/) > To unsubs

Re: [PHP] MySQL table design

2012-03-22 Thread Stuart Dallas
On 23 Mar 2012, at 00:10, Chris Stinemetz wrote: > Is it possible to create a MySQL table with characters such as "." and > "[]" in the column headers? If so would you explain how? Try putting the column names in backticks (`). BUT... whatever the reason why you want to do that, IT'S WRONG. Ser

[PHP] MySQL table design

2012-03-22 Thread Chris Stinemetz
Hello List, Is it possible to create a MySQL table with characters such as "." and "[]" in the column headers? If so would you explain how? Thank you, Chris -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP] set_error_handler() only triggering every Nth time

2012-03-22 Thread Daevid Vincent
Resending since I didn't get a single reply. Maybe it got lost? -Original Message- Sent: Tuesday, March 13, 2012 5:58 PM I am implementing a custom error handler and started noticing some bizarre behavior. Every Nth time I refresh the page, I see the error/output. In my 'includes/common.

Re: [PHP] Thinking out loud - a continuation...

2012-03-22 Thread Jay Blanchard
[snip] > At one point you indicated all the data was coming from one table. Can you > send me the table fields and indicate which fields are used to determine > parent child relationship? Also 2 sample rows of data which have a > relationship would be helpful. [/snip] Columns - tier1, tier2, ti

Re: [PHP] Thinking out loud - a continuation...

2012-03-22 Thread Robert Cummings
On 12-03-22 01:06 PM, Jay Blanchard wrote: On 3/22/2012 11:40 AM, Robert Cummings wrote: What's the field for which you are selecting data? I've written this up as a parent/child relationship but it works for data/sub-data relationships also. SELECT itemId, otherData FROM table WHERE "some cond

Re: [PHP] Thinking out loud - a continuation...

2012-03-22 Thread Jay Blanchard
On 3/22/2012 11:40 AM, Robert Cummings wrote: On 12-03-22 12:34 PM, Jay Blanchard wrote: [snip] Sorry, I just realized I didn't make the optimization explicitly obvious... when I say "Select the children" I mean to select them using an IN( id1, id2, id3 ) clause instead of a query for each. Thi

Re: [PHP] Thinking out loud - a continuation...

2012-03-22 Thread Robert Cummings
On 12-03-22 12:34 PM, Jay Blanchard wrote: [snip] Sorry, I just realized I didn't make the optimization explicitly obvious... when I say "Select the children" I mean to select them using an IN( id1, id2, id3 ) clause instead of a query for each. This is why we build the array of parent IDs (also

Re: [PHP] Thinking out loud - a continuation...

2012-03-22 Thread Jay Blanchard
[snip] Sorry, I just realized I didn't make the optimization explicitly obvious... when I say "Select the children" I mean to select them using an IN( id1, id2, id3 ) clause instead of a query for each. This is why we build the array of parent IDs (also I wrote build an array of "child IDs", i

Re: [PHP] Thinking out loud - a continuation...

2012-03-22 Thread Jay Blanchard
[snip] On 3/22/2012 11:17 AM, Robert Cummings wrote: On 12-03-22 11:58 AM, Jay Blanchard wrote: [snip] Fix this code... I've come across codebases that did this specific type of nested querying and it resulted in 1 queries to the database on every page. Instead, create a layered approach:

Re: [PHP] Thinking out loud - a continuation...

2012-03-22 Thread Robert Cummings
On 12-03-22 11:58 AM, Jay Blanchard wrote: [snip] Fix this code... I've come across codebases that did this specific type of nested querying and it resulted in 1 queries to the database on every page. Instead, create a layered approach: 1. Select your root elements. 2. Loop over i

Re: [PHP] Thinking out loud - a continuation...

2012-03-22 Thread Robert Cummings
On 12-03-22 11:58 AM, Jay Blanchard wrote: [snip] Fix this code... I've come across codebases that did this specific type of nested querying and it resulted in 1 queries to the database on every page. Instead, create a layered approach: 1. Select your root elements. 2. Loop over i

Re: [PHP] Thinking out loud - a continuation...

2012-03-22 Thread Jay Blanchard
[snip] Fix this code... I've come across codebases that did this specific type of nested querying and it resulted in 1 queries to the database on every page. Instead, create a layered approach: 1. Select your root elements. 2. Loop over in PHP and create an array of child IDs.

Re: [PHP] Thinking out loud - a continuation...

2012-03-22 Thread Robert Cummings
On 12-03-22 11:28 AM, Jay Blanchard wrote: [snip] ...stuff... [/snip] Here is the explanation for what I have done and what I am trying to do - (based on the customer's request). A week or so ago I took a set of queries from one table and made them into an unordered list. This will be pseudo-co

Re: [PHP] Thinking out loud - a continuation...

2012-03-22 Thread Jay Blanchard
[snip] ...stuff... [/snip] Here is the explanation for what I have done and what I am trying to do - (based on the customer's request). A week or so ago I took a set of queries from one table and made them into an unordered list. This will be pseudo-code so that you get idea. SELECT DISTINC

Re: [PHP] Thinking out loud - a continuation...

2012-03-22 Thread Tedd Sperling
On Mar 21, 2012, at 3:45 PM, Daniel Brown wrote: > >I would, yes, but that's not the point. Is Anna single? I'm > ready to trade Debs in for a newer model. > > -- > Ah... to be young again. But, on the other hand, they have so much to learn. :-) Cheers, tedd _ tedd

Re: [PHP] Thinking out loud - a continuation...

2012-03-22 Thread Jay Blanchard
[snip] Would it not be easier to get the data from a view which has the tables joined? Then it would be one query and it's a simple matter to format the results into the multi dimensional array then json? [/snip] The data is all from one table. I'll write up a more thorough explanation in a lit

Re: [PHP] Re: Got HTML5 History API + caching LICKED, I think,

2012-03-22 Thread rene7705
On Thu, Mar 22, 2012 at 1:01 PM, rene7705 wrote: > I've now fixed the iPad bugs in the menu component, and checked them on an > iPad in a nearby apple store. > Maybe it even works with iPhone now, if someone could check that for me > I'd be much obliged.. > > Oh, never mind to check on iPhone, th

Re: [PHP] Re: Got HTML5 History API + caching LICKED, I think,

2012-03-22 Thread rene7705
I've now fixed the iPad bugs in the menu component, and checked them on an iPad in a nearby apple store. Maybe it even works with iPhone now, if someone could check that for me I'd be much obliged.. If you're interested, http://mediabeez.ws and the download zip there are now updated with these lat

Re: [PHP] Thinking out loud - a continuation...

2012-03-22 Thread Bastien
On 2012-03-21, at 2:39 PM, Jay Blanchard wrote: > This is a continuation of the nested query thing I posted to the list a while > back. I was finally able to output a nested unordered array that worked out > well, but scope-creep has come in the door and I have to change gears. > > I have a

Re: [PHP] Node.PHP

2012-03-22 Thread Michael Save
Very nice! I'll have a proper look at this in the morning, and I'll try it out for myself. Looking forward to seeing more development on this. Michael On Thu, Mar 22, 2012 at 11:40 AM, Joseph Moniz wrote: > Hey, > > So i had my first Hackathon at work last week and my project was to > prototype