multiple output from store procedure

[vova vv]

Hello to ALL!!
I have a store procedure which consists from several 'select' and 'if' statments.
So the structure is:

CREATE DEFINER= ...... PROCEDURE `test`(
in arg_1 INTEGER,
in arg_2 INTEGER
)
BEGIN
DECLARE artisan VARCHAR(15);
DECLARE town VARCHAR(35);
DECLARE tel CHAR(16);
DECLARE tel_1 VARCHAR(20);
DECLARE podelka VARCHAR(15);
DECLARE img VARCHAR(255);
DECLARE cost SMALLINT(6);
DECLARE about VARCHAR(255);


SELECT
CFID, Name, City, Fone, Ad_fone, Art_name, Art_foto, Art_price, About_art INTO id, artisan, town, tel, tel_1, podelka, img, cost, about
FROM art INNER JOIN pers_inf
ON art.Person_id=pers_inf.Person_id
WHERE Art_id = arg_art_id;

SELECT
.....
FROM
.....
WHERE

IF... AND i...THEN
INSERT INTO ...
VALUES ..
UPDATE ....
SET ...
WHERE ....
END IF;

SELECT artisan,town,tel,tel_1,podelka,img,cost,about;
END


The problem is that I need to output the results from my FIRST SELECT - it's always 1 row. So I have to declare a lot of variables at the beginning, and I also have to put additional
SELECT artisan,town,tel,tel_1,podelka,img,cost,about - at the end

I suppose that -it's a hard recourse-intensive way.
How do it wright???

Thanks for your comments, answers!!!