SQL PHP help

[IAMPrometheus]

But I need it to go through different tables to find the user.

 

for example.

 

$this->_db->setQuery( "UPDATE #__jrleech SET `published` = '1' WHERE `id` = '". $row->id ."'" );

 

 

wont work, it needs to find it like this:

__roxsuite_membership_history -> __users.username -> __jleech.user = 1

 

The user id's are different in those 2 tables

jos_users and jos_roxsuite_membership_history id's match, but jos_jleech.user's id does not.

[Zurev]

But I need it to go through different tables to find the user.

 

for example.

 

$this->_db->setQuery( "UPDATE #__jrleech SET `published` = '1' WHERE `id` = '". $row->id ."'" );

 

 

wont work, it needs to find it like this:

__roxsuite_membership_history -> __users.username -> __jleech.user = 1

 

The user id's are different in those 2 tables

jos_users and jos_roxsuite_membership_history id's match, but jos_jleech.user's id does not.

 

You need a join, whether it be using the join keyword, or using the traditional method:

update #__jrleech, jos_users u, jos_roxsuite_membership_history m set `published` = '1' where `id` = '".$row->id."' and u.id = m.id;

 

That definitely won't work, since it's hard to understand your actual question, but that should give you some guidance as to pulling values from multiple tables.

[IAMPrometheus]

http://pastebin.com/3YHzPtFi

 

that code works for making published = 1

now I need to combine it with these 3 functions together:

http://pastebin.com/fX6nXNkM

 

So when I press approve it does all 3 at once.

 

Thanks!

[IAMPrometheus]

this is what i got so far: http://pastebin.com/9dVbqpC5 then I have combined the button to use all 3 functions at once. IE:

JToolBarHelper::publishList('approve', 'Approve').('enable').('enable2');

But to no avail. Any input?