Hi,

I have been trying to copy data from the jos_comprofiler table into another table using a user ID extracted from the latter table. It does not work.

The script also copies the email from jos_users.

Could you have a look and tell me what could possibly be wrong.

Here are the fields:

jos_comprofiler id field -> "id" or "user_id"
jos_users id field -> "id"
fab_uploads id field -> "user" (target table name and "reference" user ID field)

jos_comprofiler source field -> cb_accountnumber
fab_uploads target field -> account_number
jos_users source field -> email
fab_uploads target field -> user_email

Here is the code (not mine BTW):

I am lost.

Thanks

John

Just a quick question before reviewing your code: have you tested the queries or parts of them using a database management solution like phpMyAdmin? The error messages there usually point me into the right direction, at least you'd know if your queries are correct.

Unfortunately I do not have PHPmyAdmin installed. I use Webmin and Navicat instead.

I am running the query via Fabrik in a "submission plugin" that runs after a form is submitted.

Is there any other way to get a debug report? Should I install PHP my admin?

Thanks

Thanks Kyle...

My technical background, I am afraid, is not sufficient to allow me to properly understand the content of your tutorial. Could you point me to a resource that could help me build this "necessary" background.

But this me not be doable I admit

Thanks