Help build a box-office page
<p>Hy i'm building a cinema site, im stuck in Box-office</p>

<p>EX: <a href="http://cinema.trancelevel.com/box-office/1-iulie-7-iulie-2012/" rel="nofollow">http://cinema.trancelevel.com/box-office/1-iulie-7-iulie-2012/</a></p>

<p>The Movies are stored in Posts :
<a href="http://www.cinema.trancelevel.com/movies.jpg" rel="nofollow">http://www.cinema.trancelevel.com/movies.jpg</a></p>

<p>The Box-office are post_type:
www.cinema.trancelevel.com/box.jpg</p>

<p>In Post Type -Box-Office - i have Custom Field with Relationship that are link-ed to post's ( there are the movies)</p>

<p>When i add a Box-Office Weeke i want to add the movies in custom field, please see link 2 (www.cinema.trancelevel.com/box.jpg)</p>

<p>i want To retrive the the movie for that  i use the field_type : Relationship
with the field name: locul_1 </p>

<p>For example i have 10 custom field with relationship
In each field i want to put one movie, and get the movie: link, category,and other custom field form ( Post - www.cinema.trancelevel.com/movies.jpg )</p>

<p>I hope you understand now.</p>

<p>I have this, but this get the field from post's : www.cinema.trancelevel.com/box.jpg</p>

<p>The code:</p>

<p>`get_col("SELECT post_id FROM $wpdb->postmeta WHERE meta_key = 'distributie' AND meta_value LIKE '%".get_the_ID()."%'");
$the_query = new WP_Query( array( 'post__in' => $movies) );</p>

<p>// The Loop
while ( $the_query->have_posts() ) : $the_query->the_post();
    echo '';
    ?>
    &amp;h=90&amp;w=60&amp;zc=1" alt=""  title=""/>
    ';
endwhile;
// Reset Post Data
wp_reset_postdata();
?>`</p>

<p>If annybody know please post here. Thanks in advance </p>
