• 1

Read this first!

We do not monitor these forums. The forum is provided to exchange information and experience with other users ONLY. Forum responses are not guaranteed.

However, please submit a ticket if you have an active subscription and wish to receive support. Our ticketing system is the only way of getting in touch with RSJoomla! and receiving the official RSJoomla! Customer Support.

For more information, the Support Policy is located here.

Thank you!

TOPIC: Populate different table

Populate different table 15 years 3 months ago #6561

  • proexe
  • proexe's Avatar
  • OFFLINE
  • Junior Boarder
  • Posts: 34
Is there a way of populating the data submitted to a different table within mysql?

Your help would be much apreciated.

Kind Regards

Stewart Shram
The administrator has disabled public write access.

Re:Populate different table 15 years 3 months ago #6564

  • proexe
  • proexe's Avatar
  • OFFLINE
  • Junior Boarder
  • Posts: 34
Sorry I'm being stupid on this, answer to this is the database mapping
The administrator has disabled public write access.

Re:Populate different table 15 years 2 months ago #6611

The plugin allows creation of a new row but not the change of fields within an existing row - I've been told you need custom scripting for that (and hence don't need the plugin) - there are no example s of this type of scripting on this site (so far).
The administrator has disabled public write access.

[SOLVED] Populate different table 15 years 2 months ago #6662

The following code allows you to write data to a field in a record (I use to the cahnge a password.
this is placed in the section called Script called on form process
global $database, $myuser, $mypassword;//global declaration
$myuser = $_POST['form']['userid'] ;
$mypassword = $_POST['form']['new'] ;
{
mysql_query("update users set users.password = '$mypassword'  where id = $myuser");
}

userid is a field in the form (hidden) which contains the id of the user
new is a field in the form that contains the new password
the mysql_query updates a table called users user.password is the table and the field to update
Last Edit: 15 years 2 months ago by ian.scott.
The administrator has disabled public write access.
  • 1

Read this first!

We do not monitor these forums. The forum is provided to exchange information and experience with other users ONLY. Forum responses are not guaranteed.

However, please submit a ticket if you have an active subscription and wish to receive support. Our ticketing system is the only way of getting in touch with RSJoomla! and receiving the official RSJoomla! Customer Support.

For more information, the Support Policy is located here.

Thank you!