51 Posts
ostap
5 years ago
5
Topic

Hello!

I'm sorry, try to contact the forum only on those problems the solution of which are not found.

So. I Use "Search Query". It is clear that the SQL query refers to the database tables of my site. I have a need to temporarily access tables on an external site (I have them prepared by other people). It is clear that the connection to the database uses a construction such as the following:

$$link = mysql_connect($hostname, $username, $password, $dbname);

etc.

Question:

How to connect to an external database and use "Search Query"?

Get a VIP membership
4229 Posts
Kadministrator
5 years ago
1
Level 1

You can't, search query is only meant to manipulate search query that will be executed on the current database. Perhaps you could do this with some code field..or in the template,.

51 Posts
ostap
5 years ago
0
Level 2

I understood. Thank. SQL-query (inside the Search Query) can I use the field value in the current field sets? (Sorry for the stupid question, but I did not find it on the forum)

51 Posts
ostap
5 years ago
1
Level 2

Thanks Klaus!

This is a really great plugin. I bought it just two days ago, but did not understand its action until tested today.

I understood how this plugin works in "Live Value" mode and "Restriction"mode. How it works in the "Field" is not understood?!

Tried to describe in more detail my situation in in a new message:

https://www.seblod.com/community/forums/lists-search-types/list-search-type-search-query-field-plugin-how-to-display-a-list-without-rel

Can be someone will help…

4229 Posts
Kadministrator
5 years ago
0
Level 3

It is only usable in the content or list, where "as field" executes the query and displays the result. In the form it jsut renders am ordinary text field without the query having any results.

Get a VIP membership