From mboxrd@z Thu Jan 1 00:00:00 1970 Path: news.gmane.org!not-for-mail From: "Lennart Borgman" Newsgroups: gmane.emacs.help Subject: Re: indenting SQL in php_mode Date: Mon, 8 Dec 2008 17:27:36 +0100 Message-ID: References: <87iqpvojkw.fsf@stars.fthieme.lan> <87r64ilyan.fsf@stars.fthieme.lan> <87myf6lq9z.fsf@stars.fthieme.lan> NNTP-Posting-Host: lo.gmane.org Mime-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit X-Trace: ger.gmane.org 1228754281 8432 80.91.229.12 (8 Dec 2008 16:38:01 GMT) X-Complaints-To: usenet@ger.gmane.org NNTP-Posting-Date: Mon, 8 Dec 2008 16:38:01 +0000 (UTC) Cc: help-gnu-emacs@gnu.org To: "Frank Thieme" Original-X-From: help-gnu-emacs-bounces+geh-help-gnu-emacs=m.gmane.org@gnu.org Mon Dec 08 17:39:04 2008 Return-path: Envelope-to: geh-help-gnu-emacs@m.gmane.org Original-Received: from lists.gnu.org ([199.232.76.165]) by lo.gmane.org with esmtp (Exim 4.50) id 1L9j8A-0001Jx-3e for geh-help-gnu-emacs@m.gmane.org; Mon, 08 Dec 2008 17:38:46 +0100 Original-Received: from localhost ([127.0.0.1]:37550 helo=lists.gnu.org) by lists.gnu.org with esmtp (Exim 4.43) id 1L9j6z-0000Qm-2r for geh-help-gnu-emacs@m.gmane.org; Mon, 08 Dec 2008 11:37:33 -0500 Original-Received: from mailman by lists.gnu.org with tmda-scanned (Exim 4.43) id 1L9ixS-0006pZ-4A for help-gnu-emacs@gnu.org; Mon, 08 Dec 2008 11:27:42 -0500 Original-Received: from exim by lists.gnu.org with spam-scanned (Exim 4.43) id 1L9ixP-0006ov-4k for help-gnu-emacs@gnu.org; Mon, 08 Dec 2008 11:27:39 -0500 Original-Received: from [199.232.76.173] (port=46445 helo=monty-python.gnu.org) by lists.gnu.org with esmtp (Exim 4.43) id 1L9ixO-0006od-Ot for help-gnu-emacs@gnu.org; Mon, 08 Dec 2008 11:27:38 -0500 Original-Received: from ey-out-1920.google.com ([74.125.78.146]:14380) by monty-python.gnu.org with esmtp (Exim 4.60) (envelope-from ) id 1L9ixO-0007QO-9s for help-gnu-emacs@gnu.org; Mon, 08 Dec 2008 11:27:38 -0500 Original-Received: by ey-out-1920.google.com with SMTP id 4so485808eyg.24 for ; Mon, 08 Dec 2008 08:27:36 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to :subject:cc:in-reply-to:mime-version:content-type :content-transfer-encoding:content-disposition:references; bh=duzgYuTSLkzkZr44aEd6zmTFn1SVyvzFIIxREUPhC+8=; b=c8agEKKmfG6BwyX5L+u5nBIq0LaeMUbEF+IdkUf7tj/frtWChr/EyZDivxLRvAheP0 Golkrr3VOyOWJdDnznx3vKaujWFj5KbL/U16x2fRIbNPHPDzuHwXzr95C7FheDnop22d Hyy33elIVWvlZSCs0FIW9jpwk92vMlqJ6IHd0= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:cc:in-reply-to:mime-version :content-type:content-transfer-encoding:content-disposition :references; b=ThSfrBi+5JwvxtJl1KeM9LRwFKgTiYE+qdx/qzSxu6Rd+afYfii91BHLKu94RTqoe+ h3qRbSH4ZJiubQzfr7WJ04nN57Fzooy+i7LLqrEFIbmZyiuc75wYYhawAQkV1YHpAsjI pSVVSa6srPhdQHKV7CYX3APPusNigcqF0U15s= Original-Received: by 10.86.59.18 with SMTP id h18mr2750445fga.31.1228753656646; Mon, 08 Dec 2008 08:27:36 -0800 (PST) Original-Received: by 10.86.58.16 with HTTP; Mon, 8 Dec 2008 08:27:36 -0800 (PST) In-Reply-To: <87myf6lq9z.fsf@stars.fthieme.lan> Content-Disposition: inline X-detected-operating-system: by monty-python.gnu.org: GNU/Linux 2.6 (newer, 2) X-BeenThere: help-gnu-emacs@gnu.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Users list for the GNU Emacs text editor List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Original-Sender: help-gnu-emacs-bounces+geh-help-gnu-emacs=m.gmane.org@gnu.org Errors-To: help-gnu-emacs-bounces+geh-help-gnu-emacs=m.gmane.org@gnu.org Xref: news.gmane.org gmane.emacs.help:60460 Archived-At: On Mon, Dec 8, 2008 at 3:01 PM, Frank Thieme wrote: > On Mo 08 Dez 2008 14:32, "Lennart Borgman" writes: > >> Could you please show me some examples of how sql in php look? (Delimiters etc.) > > I don't know whether there is a standard, but I do it like this: > > $query = "SELECT field1, > field2, > field3 > FROM table1 t1, > table2 t2 > WHERE t1.foo = t2.bar > AND field1 = 'foobar'"; Thanks, Frank, but I thoiught you meant a file with mixed php and sql code, or? How does the delimiters from the php code look?