Help with a query and insert?

[bnovak]

I could really use a hand with this from someone smarter than I am.

 

I have two tables (same db) Profile and Subscriptions that look like this

 

Profile

ID(pk) | login | chooseAccount | account  -> account is set to "empty" automatically.

 

Subscriptions

ID(pk) | login | type  -> the ID's DO NOT line up between the two tables but the login does and login is a unique value

 

I need to do this query

mysql_query("UPDATE profile SET account='Enrollment Manager - Standard' 
WHERE subscriptions.type LIKE '%manager%' and account= 'empty'");

mysql_query("UPDATE profile SET account='Enroller - Standard' WHERE account= 'empty' ");

(Sorry, I know it's in PHP context)

 

What I am lost in trying to figure out is how to do it row by row -> matched by login?

 

Basically -

 

if profile.account="empty" query subscriptions.type and insert into profile.account"Enrollment Manager - Standard" if subscriptions.type contains "manager" else insert into profile.account "Enroller - Standard"

 

make sense?

 

[fenway]

Use CASE.