Skip to Content Skip to Menu

Get region from other database with MySQLfield

  • josama
  • josama
  • OFFLINE
  • Posts: 2
  • Thanks: 0
  • Karma: 0
13 years 11 months ago #148833 by josama
Hello
I an using your plugin but i got a problem.


I will explain wat i want: i have a userfield (cb_postcode) where the
user puts as example 1234as for the postalcode
now i have a other database with regions and postcodes. your plugin
needs to get the regions out the database with as refferal the postcode.

for this i use a mysqlfield field, named mysqlfieldregio

MySQL statement:
================
result type: Single
SELECT: Jia_regio
FROM: postcodes
WHERE: {VIEWERID} = cb_postcode

Field Output
=============
Output mode Both
Fieldname: cb_regio
Profile display All
Use substitusion: no

Can you help me please,

Please Log in or Create an account to join the conversation.

Moderators: beatnantkrileon
Powered by Kunena Forum