Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: Select and order by question
- From: John DeSoi <desoi(at)pgedit(dot)com>
- To: <operationsengineer1(at)yahoo(dot)com> <operationsengineer1(at)yahoo(dot)com>
- Cc: "Sherwin M. Harris" <Sherwin_Harris(at)byu(dot)edu>, pgsql-php(at)postgresql(dot)org
- Subject: Re: Select and order by question
- Date: Wed, 3 May 2006 15:25:24 -0400
On May 3, 2006, at 12:12 PM, <operationsengineer1(at)yahoo(dot)com> <operationsengineer1(at)yahoo(dot)com> wrote:
off topic, but still relevant to php sql. i'll share something that has made my life much easier wrt sql statements - heredocs. the format looks like this: $sSql = <<<_ESQL SELECT * FROM crm_events WHERE crm_leads_id IN (SELECT id FROM crm_leads) AND follow_up_action!='' ORDER BY follow_up_date asc limit 1 _ESQL
A little shameless promotion: pgEdit will even color the heredoc string for SQL if you start your heredoc string with <<<sql. Works for <<<html also.
I'll have a short article out soon that shows how you can pretty much remove all SQL from your PHP code using a simple PHP class and PostgreSQL functions.
John DeSoi, Ph.D. http://pgedit.com/ Power Tools for PostgreSQL
- References:
- Re: Select and order by question
- From: operationsengineer1
- Re: Select and order by question
- Prev by Date: Re: Select and order by question
- Next by Date: Re: Select and order by question
- Previous by thread: Re: Select and order by question
- Next by thread: Re: Select and order by question
- Indexes: