My SQL skills are minimal, so I would greatly appreciate any help. What i am trying to do is update multiple user listing records when their account expires. The fields and tables are as follows:
TABLE1
user_name
user_id
TABLE2
user_id
listing_id
listing_status
The user_name in these tables is equal to [username] in CB, but the user id numbers are different.
What I think I need to do is find the user_id where user_name=username. But after that I'm lost.
What I need to do is find all listing_ids for that user_id, then set the listing_status of all of those to 'no'. I just don't know how to get there.
Any help would be greatly appreciated. Thank you.
Post edited by: skosloff, at: 2010/06/01 01:58
Post edited by: krileon, at: 2010/06/01 15:35