sql procedure

[Gary Corcoran]

Hi

I'm trying to make a procedure to use in phpmyadmin

1. It starts with finding a user

SELECT * FROM `b_users` where email like '%.ru'

2. that list then I would like to see if they have anything listed... ie: for user id 155

SELECT id, title FROM b_auctions WHERE user = 155
SELECT * FROM b_bids WHERE bidder = 155
SELECT suspended FROM b_users WHERE id = 155
DELETE FROM b_users WHERE id = 155
SELECT c.level, c.left_id, c.right_id FROM b_auctions a LEFT JOIN b_categories c ON (a.category = c.cat_id) WHERE a.user = 155
UPDATE b_categories SET counter = counter - 1, sub_counter = sub_counter - 1 WHERE cat_id = 1
UPDATE b_categories SET counter = counter - 1, sub_counter = sub_counter - 1 WHERE cat_id = 7
UPDATE b_categories SET counter = counter - 1, sub_counter = sub_counter - 1 WHERE cat_id = 95
DELETE FROM b_auctions WHERE user = 155
UPDATE b_counters set users = users - 1, bids = bids - 0, auctions = auctions - 1


I need to do this but off the first query.. no.1

Thanks for looking