Help with UNION query

[Anon]

CREATE TEMPORARY TABLE tbl_temp
SELECT artist_id,artist_name FROM tbl_artist WHERE artist_name = 'unknown';
INSERT INTO tbl_temp
SELECT artist_id,artist_name FROM tbl_artist WHERE artist_name <> 'unknown'ORDER BY artist_name;
SELECT * from tbl_temp;

what is the best way to execute this command in php. i'm new to php and mysql so i'm kinda experiencing difficulties.

any help would be greatly appreciated.

[Anon]

Well, there is this wonderfull thing called a "manual" which explains exactly how you should connect to a database and how you can execute queries and retreive the results.

It's really a matter of a few statements and you're done.