I have a content type with two fields: Exterior Images and Interior Images
Both of these fields are Unlimited Values – so the user can upload as many images as they want to exterior and interior. Screenshots: http://prntscr.com/a9m8o5 http://prntscr.com/a9m8uc
Now I’m trying to create a view that grabs all exterior and interior images uploaded and displays them.
The only way I can find to have each image displayed as its own individual field and row is to perform a UNION betwen something like SELECT exterior UNION SELECT interior etc. etc. but I just can’t seem to figure out the rest.
I’ve tried creating two views and combining them like this:
function pgallery_views_pre_execute(view &$view){ if ($view->name == 'photo_gallery'&& $view->current_display == 'page_1') { // View 1 contains Interior Images $view1 = views_get_view('photo_gallery'); $view1->build('block_1'); $query1 = $view1->build_info['query']; // View 2 contains Exterior Images $view2 = views_get_view('photo_gallery'); $view2->build('block_2'); $query2 = $view2->build_info['query']; $query1->union($query2); $view->build_info['query'] = $query1; } } but it won’t render whatever is in $query2 – it just repeats $query1 values. So I get the correct number of “rows” from the result but it repeats the data for some reason. Please help!
