[nyphp-talk] Note: PHP Meetup

2008-04-22 Thread Hans Zaunere
Hi all, I'd like to let everyone know about our PHP Meetup organization efforts. On the 1st Tuesday of every month, at 6:30pm, we'll be getting together at Pound and Pence for an informal gathering of PHP, web, and open source folks. Details are at http://php.meetup.com/430/ The meetups will be

RE: [nyphp-talk] MySQL - SQL Question

2008-04-22 Thread Hans Zaunere
Hi Kristina, > //== > SELECT i.id, i.name, i.whatever, > COALESCE(i.specific1, d.default1) as val1, > COALESCE(i.specific2, d.default2) as val2 > FROM tblInstance i > LEFT OUTER JOIN tblDefault d > ON i.foreignKey = d.primaryKey; > > COALESCE selects the first non-null value of its arguments,

Re: [nyphp-talk] MySQL - SQL Question

2008-04-22 Thread Kristina Anderson
//== SELECT i.id, i.name, i.whatever, COALESCE(i.specific1, d.default1) as val1, COALESCE(i.specific2, d.default2) as val2 FROM tblInstance i LEFT OUTER JOIN tblDefault d ON i.foreignKey = d.primaryKey; COALESCE selects the first non-null value of its arguments, and the left outer join makes

Re: [nyphp-talk] MySQL - SQL Question

2008-04-22 Thread Daniel Convissor
Hi John: On Tue, Apr 22, 2008 at 01:31:52PM -0400, John Campbell wrote: > > I have a products table with a standard auto number primary key, and a > descriptions table that is keyed off the product id and a language id > ('en','es','zh_cn', etc) ... > SELECT product.id, product.price, (SELECT d.d

Re: [nyphp-talk] preforming a task after x hours

2008-04-22 Thread David Mintz
On Tue, Apr 22, 2008 at 5:07 PM, Bruce Martin <[EMAIL PROTECTED]> wrote: > Hi,Is there a way to set a process to run every x hours in PHP? > > I don't think there's any graceful way, but there's certainly a way known as cron that is meant for just that very thing. -- David Mintz http://davidmin

Re: [nyphp-talk] preforming a task after x hours

2008-04-22 Thread Mark Armendariz
Bruce Martin wrote: Hi, Is there a way to set a process to run every x hours in PHP? look up cron or cronw depending on your platform. Mark ___ New York PHP Community Talk Mailing List http://lists.nyphp.org/mailman/listinfo/talk NYPHPCon 2006 Presen

[nyphp-talk] preforming a task after x hours

2008-04-22 Thread Bruce Martin
Hi, Is there a way to set a process to run every x hours in PHP? Bruce Martin The Martin Solution [EMAIL PROTECTED] http://www.martinsolution.com http://externals.martinsolution.com ___ New York PHP Community Talk Mailing List http://lists.nyphp.org/

Re: [nyphp-talk] MySQL - SQL Question

2008-04-22 Thread John Campbell
On Tue, Apr 22, 2008 at 2:10 PM, Kenneth Dombrowski <[EMAIL PROTECTED]> wrote: > SELECT > p.id , > p.price , > IF(d.description, d.description, en.description) AS description , > IF(d.lang_id, d.lang_id, en.lang_id) AS lang_id > FROM product AS p > INNER JOIN user

Re: [nyphp-talk] Greetings

2008-04-22 Thread Nate Abele
Date: Tue, 22 Apr 2008 12:09:25 -0400 (EDT) From: Ajai Khattri <[EMAIL PROTECTED]> Subject: Re: [nyphp-talk] Greetings To: NYPHP Talk On Tue, 22 Apr 2008, Erik Schoster wrote: I can attest to symfony. As someone who forced themselves to shirk frameworks while I learned PHP, I do enjoy a good

Re: [nyphp-talk] MySQL - SQL Question

2008-04-22 Thread Kenneth Dombrowski
Hi John, On 08-04-22 13:31 -0400, John Campbell wrote: > > I have a products table with a standard auto number primary key, and a > descriptions table that is keyed off the product id and a language id > ('en','es','zh_cn', etc) > > I want to join the description table to the product table on

Re: [nyphp-talk] About Formalizing an Enterprise PHP and the PHP+Developer

2008-04-22 Thread Tim Gales
Peter Sawczynec wrote: [...] Most businesses/new processes brought about through fresh initiative are just brought together as best as can be done right now while the iron is hot ... Many business profess that they want to have people who can think 'outside of the box' and yet they cling to a '

Re: [nyphp-talk] MySQL - SQL Question

2008-04-22 Thread Jake McGraw
Ah, assuming you don't know the language prior to creating the query, I think you'd use something like: SELECT product.id , product.price , IF (lang_id IS NULL, 'en', lang_id) AS lang_id FROM product LEFT JOIN descriptions ON product.id = descriptions.produc

[nyphp-talk] MySQL - SQL Question

2008-04-22 Thread John Campbell
I am a bit stumped on this one. I have a products table with a standard auto number primary key, and a descriptions table that is keyed off the product id and a language id ('en','es','zh_cn', etc) I want to join the description table to the product table on a 1:0,1 basis, and if the users langua

RE: [nyphp-talk] About Formalizing an Enterprise PHP and the PHP+Developer

2008-04-22 Thread Peter Sawczynec
You know, not being able to go forward with a plan/concept/task because "well, you know, all of the things that need to be in place for perfection are not in a perfect state" and so therefore we do nothing, is not how inspiring, new, bold work gets done. Most businesses/new processes brought about

RE: [nyphp-talk] About Formalizing an Enterprise PHP and the PHP+Developer

2008-04-22 Thread Peter Sawczynec
I believe in cert in general. I believe it provides a real tool for any journeyman in any industry to launch themselves on a known career path. So I would have to answer yes. If a programmer has the knowledge and poise to successfully rise to the series of questions and situations that are posed

Re: [nyphp-talk] About Formalizing an Enterprise PHP and the PHP+ Developer

2008-04-22 Thread Tom Melendez
So, "recognized user group member" And what does this actually mean? Active on a mailing list? Shows up at meetings? Knows the organizer of the group? Pays dues? As the founder and past president of LIPHP I can say that this is hard to validate. Sure, there are people in the group and on th

Re: [nyphp-talk] About Formalizing an Enterprise PHP and the PHP+ Developer

2008-04-22 Thread David Krings
Peter Sawczynec wrote: d) we have a handful of large free PHP user groups and these groups, say the top 10, should be formally recognized, and one should be expected to belong to one of these groups. I understand the motivation, but I don't think mandating a membership in a club is helpful. An

Re: [nyphp-talk] About Formalizing an Enterprise PHP and the PHP+Developer

2008-04-22 Thread Scott Mattocks
Peter Sawczynec wrote: I believe that all of the informal industry-standard acknowledgements and accolades that you call for in your note have already been informally applied to all the entities that you mention and that this informal approved/sanctioned condition has existed for years for PEAR,

RE: [nyphp-talk] About Formalizing an Enterprise PHP and the PHP+Developer

2008-04-22 Thread Kristina Anderson
>I am still in the camp that PHP programmers like realtors, > financial planners should have an association approved path and tool set > that ultimately will have more knowable and strongly negotiable pay > scale. YES!! Yes yes yes. Realistically speaking, though, nobody is going to like being

Re: [nyphp-talk] Greetings

2008-04-22 Thread Ajai Khattri
On Tue, 22 Apr 2008, Erik Schoster wrote: > I can attest to symfony. As someone who forced themselves to shirk > frameworks while I learned PHP, I do enjoy a good framework. Symfony > has impressed me recently. We're in good company (Yahoo). :-) -- Aj.

Re: [nyphp-talk] About Formalizing an Enterprise PHP and the PHP+ Developer

2008-04-22 Thread Tim Gales
Peter Sawczynec wrote: [...] And that a programmer who has Zend cert. and is a recognized user group member can use the status of PHP+ user/programmer on their credentials/resume. Is being Zend certified (alone) a big help? -- T. Gales & Associates 'Helping People Connect with Technology'

RE: [nyphp-talk] About Formalizing an Enterprise PHP and the PHP+Developer

2008-04-22 Thread Peter Sawczynec
I would have nothing against an independently created and sanctioned PHP cert devised/approved by the author/core developers, but it seems that would be a big waste of how far Zend has already taken things and it does not seem like there is sufficient momentum/cohesion to firmly establish such an i

RE: [nyphp-talk] About Formalizing an Enterprise PHP and the PHP+Developer

2008-04-22 Thread Peter Sawczynec
I believe that all of the informal industry-standard acknowledgements and accolades that you call for in your note have already been informally applied to all the entities that you mention and that this informal approved/sanctioned condition has existed for years for PEAR, sourceforege.net, et al.

Re: [nyphp-talk] About Formalizing an Enterprise PHP and the PHP+ Developer

2008-04-22 Thread Scott Mattocks
Peter Sawczynec wrote: It seems we (I mean PHP programmers) have all the tools and instruments already at our fingertips for more formalizing the study and application of PHP, we'd just have to agree to ring our wagons around what we've got on hand. Instead of trying to force a few applications

RE: [nyphp-talk] About Formalizing an Enterprise PHP and the PHP+Developer

2008-04-22 Thread Peter Sawczynec
I believe that a starting point for a governing entity would be the author of PHP (and/or his appointed representatives/associates), the core developers of PHP itself (including Zend), and possibly the current top-level leadership of the major User Groups. Review is annual as most other such self-r

RE: [nyphp-talk] About Formalizing an Enterprise PHP and the PHP+Developer

2008-04-22 Thread Peter Sawczynec
I believe that every person/entity that could put academic/professional/commercial/author weight behind the formalization of this idea is on this list. Peter -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ben Sgro Sent: Tuesday, April 22, 2008 11:02 AM To

Re: [nyphp-talk] About Formalizing an Enterprise PHP and the PHP+ Developer

2008-04-22 Thread Rolan Yang
Peter Sawczynec wrote: So what would be wrong if we just agreed as a professional group to use these above entities as our bedrock standards. We use the Zend cert, the Zend IDE/framework and officially sanction Php.net and Sourceforge.net/PEAR as the defacto outlets of help/reference and code.

RE: [nyphp-talk] About Formalizing an Enterprise PHP and the PHP+Developer

2008-04-22 Thread Jason Scott
I voice my vote in favor, as well, and offer my - and my company's - full support as needed. Jason Scott | Chief Information Officer 233 Broadway, 21st Floor, New York, NY 10279 Ph: 212.509.5218 ext 226 | Fax: 866-797-0971 innovationads.com -Original Message- From: [EMAIL PROTECTED]

Re: [nyphp-talk] About Formalizing an Enterprise PHP and the PHP+ Developer

2008-04-22 Thread Ben Sgro
Hello Peter/et all, I agree with a lot of this. I've been thinking about the same thing since the "OT Webmaster Test" thread started. Some kind of move like this would surely help increase the quality of software and allow those new to a project to become productive more quickly. This is ba

[nyphp-talk] About Formalizing an Enterprise PHP and the PHP+ Developer

2008-04-22 Thread Peter Sawczynec
It seems we (I mean PHP programmers) have all the tools and instruments already at our fingertips for more formalizing the study and application of PHP, we'd just have to agree to ring our wagons around what we've got on hand. For example: a) we have the very large and well-recognized repository

Re: [nyphp-talk] Greetings

2008-04-22 Thread Nayef Abu Ebaid
I would go for Zend Frame work, in our company we used (Code Igniter, Symfony, and Zend Frame). Zend is the best and very powerful. Erik Schoster wrote: I can attest to symfony. As someone who forced themselves to shirk frameworks while I learned PHP, I do enjoy a good framework. Symfony has

Re: [nyphp-talk] Greetings

2008-04-22 Thread Erik Schoster
I can attest to symfony. As someone who forced themselves to shirk frameworks while I learned PHP, I do enjoy a good framework. Symfony has impressed me recently. Erik On Apr 22, 2008, at 8:57 AM, Ajai Khattri wrote: On Tue, 22 Apr 2008, Bruce Martin wrote: Thanks, I'll look into it. O

Re: [nyphp-talk] Greetings

2008-04-22 Thread Ajai Khattri
On Tue, 22 Apr 2008, Bruce Martin wrote: > Thanks, I'll look into it. Often when I start out with a different > language I try to stick to writing my own code, so I can get to know > the language itself. Then after at least one project I find my way to > using the libs or frameworks. I will

Re: [nyphp-talk] Greetings

2008-04-22 Thread Bruce Martin
Thanks, I'll look into it. Often when I start out with a different language I try to stick to writing my own code, so I can get to know the language itself. Then after at least one project I find my way to using the libs or frameworks. I will look into the Zend Framework though, it sounds i

Re: [nyphp-talk] Greetings

2008-04-22 Thread Ben Sgro
Welcome!!! +1 Zend framework. Starting using it a few weeks ago. Really enjoying it. - Ben Jake McGraw wrote: The cookie problem you're having, have you considered using a framework to take the guess work out of when it is appropriate to set a cookie (ie send a header)? Using a consistent meth

Re: [nyphp-talk] Greetings

2008-04-22 Thread Jake McGraw
The cookie problem you're having, have you considered using a framework to take the guess work out of when it is appropriate to set a cookie (ie send a header)? Using a consistent method for processing requests and delivering pages will often make the whole issue trivial. I would suggest the Zend

[nyphp-talk] Greetings

2008-04-22 Thread Bruce Martin
Hi, I just joined the list and thought I would introduce myself. I have been programming since 1995, well before that if you include the years I spend toying with BASIC. I just recently started using PHP, I find it well thought out, although there are somethings that take some time to get u