“UNION ALL”不检索结果，或者错误地复制结果

Question

First let me explain I'm not very familiar with retrieving data from two or more tables. I have two tables, one for images and the other for videos. I am attempting to pull entries from both to list together on one page and ordered together so they're mixed in with each other in the results.

The code is as follows...

            $result_media = @mysql_query(" 
                (SELECT 
                videos.url AS video_url,  
                videos.description AS video_description
                FROM videos)

                UNION ALL

                (SELECT 
                images.url AS image_url
                FROM images
                WHERE (images.url != 'nopic.png') ) LIMIT 25");

            while ($row = mysql_fetch_array($result_media)) {

                $video_url = $row['videos_url'];
                $video_thumbnail = $row['video_thumbnail'];
                $video_description = $row['video_description'];

                $image_url = $row['image_url'];

                [echo results]
            }

Nothing is displayed unless I remove ", videos.description AS video_description" but then of course the data doesn't show up right.

Secondly, when I do get results to display (worked with INNER JOIN) all results are duplicated.

Any ideas?

Thanks for the help!