Show Posts

Profile Info
- Summary
- Show Stats
- Show Posts

This section allows you to view all Show Posts made by this member. Note that you can only see Show Posts made in areas you currently have access to.

Messages - jfgonzalez

Questions / Re: What are the accepted "Query Params"

June 25, 2019, 07:31:05 PM

thank u for the answers.
this is form
OptionList1: Countrys
OptionList2: States
OptionList3: Cities

1. Select id,name from countrys
2. select id_state,name from states where id_country=xxx
3. select id_citie,name from cities where id_country=abc and id_state=jmk

For second option list its working but third Not.
My answer is how i can get values from elements selected an run query

Questions / Re: What are the accepted "Query Params"

June 25, 2019, 02:10:09 AM

this query
select id,name
from customers
where country=xxxx
and state=yyyyy

Questions / Re: What are the accepted "Query Params"

June 21, 2019, 02:21:36 AM

Quote from: Emman – January 25, 2019, 04:23:16 AM

Hi ewwgee.

You can pass in any variable to the query parameter list.

Here's is a sample statement.

( !empty( $_GET['category'] ) ? $_GET['category'] : null )

and two fields values or variables?

Questions / Re: Field datasource with conditional

June 21, 2019, 02:02:15 AM

but, how i can build a query where clause with two fields values

Questions / Re: Field datasource with conditional

June 17, 2019, 02:59:52 PM

Hi, Do you have any solution for this :
My goal is to figure if something like this is doable with current PHPRad tools, maybe with query parms, as I see something like this $lookup_country is added to query params in the case of simple scenarios. Would be possible to add 2 and make the query more complex