Re: Re: Basic Dual Query Combine into one question
| From: | Andy McKenzie | Date: | Fri, 23 Jan 2015 17:15:31 +0000 |
| Subject: | Re: Re: Basic Dual Query Combine into one question | ||
| References: | 1 2 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-324291@lists.php.net to get a copy of this message | ||
On Fri, Jan 23, 2015 at 11:52 AM, dealTek <dealtek@gmail.com> wrote:
>
> On Jan 22, 2015, at 5:50 PM, dealTek <dealtek@gmail.com> wrote:
>
> >
> > ... I needed to do two separate queries to the same mysql contacts table
> (rather than one more elegant combined one)
> >
>
>
>
> Hi folks,
>
> I stated something incorrect (late night last night) - I said mysql table
> but in fact this is using filemaker backend and I don't believe that I can
> do complex php queries with filemaker as described - so I was going to just
> do 2 different queries and combine them... hope that helps
>
>
It looks like FileMaker 12 does allow more complex queries:
http://filemakerhacks.com/2012/10/19/the-missing-fm-12-executesql-reference/
It looks like It's a pretty standard SQL query, now. Build the SELECT
statement, then use ExecuteSQL() to run it.
Andy