Okay guys, the code below works fine. Except that since I have given users up to 4 image downloads, the product preview page should only display 1 of the images like the first one in the array in the product page but it shows all rows if the user uploads like 4 images. how can I limit this? thanks.

```
<?php           
        echo 'Your posts:' . '<br>' . '<hr>'; 

        $posts = "SELECT * FROM posts,image_data WHERE userid='$user' AND user_posts.userid = image_data.client_id ORDER BY date_created ASC";
        $posts_result = $mysqli->query($posts);     
        while ($posts_result_rows = $posts_result->fetch_assoc()) {
            $its_id = $posts_result_rows["userid"];
                        $its_title = $posts_result_rows['post_title']; 
                        $its_image = $posts_result_rows['file'];
                        $its_description = $posts_result_rows['post_description'];
        ?>
        <table border=0 cellpadding=5 cellspacing=0 >
            <tr>
                        <?php echo '<br>' . $its_title . ' <br>' . $its_description . '<br>'; ?>
                        <img src="<?php echo "users_data/users_posted_data/".$its_image; ?>" alt="<?php echo $its_title; ?>" width="120" height="120"><hr>                   
            </tr>
        </table>
        <?php 
            }
        ?>          

```