在表中显示SQL数据

Question

A few months ago, I made a system where people could upload a picture and then those pictures would be displayed in a table with 4 columns. Now I am working on a project (to practice my php, I am still learning it) and I would like to use a similar system as below but it should display data from a database. The result I was trying to achieve is the data being displayed in 2 columns.

if ($handle = opendir('images/')) {
    $bool = true;
    while ($bool) {
       $td = 1;
       echo '<tr>';
       while ($td < 4) {
          $file = readdir($handle);
          if ($file != '.' && $file != '..' && $file != '.DS_Store') {
             echo '<td>';
             if ($file) {
                echo '<img src="images/'.$file.
                '">';
             } else {
                $bool = false;
             }
             echo '</td>';
             $td++;
          }
       }
       echo '</tr>';
    }
 }
 closedir($handle);

Answer 1

For anyone looking for the answer:

 $query = "SELECT * FROM webshop";
                if($query_run = mysql_query($query)) {
                    $bool = true;
                    echo '<table>';
                    while($bool) {
                        $td = 0;
                        echo '<tr>';
                        while($td < 2) {
                            if($fetch = mysql_fetch_assoc($query_run)) {
                                echo '<td>';
                                $title = $fetch['title'];
                                $info = $fetch['info'];
                                /* Commented out for now, will be implemented later
                                $image = $fetch['image'];
                                $price = $fetch['price'];
                                */
                                echo $title;
                            } else {
                                $bool = false;
                            }
                            echo '</td>';
                            $td++;
                        }
                        echo '</tr>';
                    }
                    echo '</table>';
                }