Hi guys, had a look around for the field names i need for this query..seen it before, but now i need it cant find it!!
I am wanting to a query to update the profile logger DB to show which user Approved a profile.
The 2 fields i am wanting are the ID fields..what are the substitutes here please or where can i find them..
I have used fixed valuse..thats on purpose.. just the ID am after
IE
Update `#__evyhc_comprofiler_plug_pulogger`
(`changedate`, `profileid`, `editedbyid`, `mode`, `fieldname`, `oldvalue`, `newvalue`)
Select NOW(), `id`(this is the member being approved id??), `user_id`(this is the user doing the approval??), '1', 'User_groups', 'waiting approval', 'approval updated'
FROM `#__Comprofiler`