Hello everyone,
I have two tables," members" and "members_old"
The grid of the table "members_old" is visible in the designer from phprunner.
I have placed a custom_button in the designer, and when I press the button, the intention is that the value from the fieldname "name" from the table members_old is placed with the correct member number in the table "members" (so an update of the table "members" )
On the server side I wrote the following code:
while($record = $button->getNextSelectedRecord())
{
$sql = "Update members set name =" .$record["name"] where membernumber=".$record["membernumber"];
DB::Exec($sql);
}
CustomQuery($sql);But the code doesn't work.... Who can help me, what's the right code? thanks.