title: custom Wordpress pagination for a specific table
body: <p>I have a Wordpress website about streaming movies and I've created a table 'movies' in MYSQL. and when I want to show movies into my page it shows all the movies and I want just 12 per page. should I use the traditional pagination or there is a trick in wordpress that could help me.
  wordpress pagination works fine only on posts table.
  by the way I've used $wpdb.</p>
  
  <pre><code>global $wpdb;
    $movies = $wpdb-&gt;get_results("select * from movies");
    foreach ($movies as $key =&gt; $movie) {// code}
  </code></pre>