title: Doing while with html and php
body: <p>Hello i have done whiles with php but never html...
  I have a script that works fine but looks ugly so a friend has made me a html layout.</p>
  
  <p>Here is my php script.</p>
  
  <pre><code>&lt;p&gt;
  
  
      &lt;?php
          /* Place code to connect to your DB here.     */
  
  
          $tbl_name="adds";        //your table name
          // How many adjacent pages should be shown on each side?
          $adjacents = 3;     
          /* 
          First get total number of rows in data table. 
          If you have a WHERE clause in your query, make sure you mirror it here.
          */
  
          $query = "SELECT COUNT(*) as num FROM adds ";
          $total_pages = mysql_fetch_array(mysql_query($query));
          $total_pages = $total_pages['num'];  
          /* Setup vars for query. */
          $targetpage = "earn.php";     //your file name  (the name of this file)
          $limit = 6;     
          //how many items to show per page
          $page = isset($_GET['page']) ? $_GET['page'] : 0;
          if($page) 
              $start = ($page - 1) * $limit;
          //first item to display on this page
          else 
              $start = 0;                                //if no page var is given, set start to 0     
          /* Get data. */
          $sql = "SELECT * FROM $tbl_name LIMIT $start, $limit ";
          $result = mysql_query($sql);
          /* Setup page vars for display. */
          if ($page == 0) $page = 1;                    //if no page var is given, default to 1.
          $prev = $page - 1;                            //previous page is page - 1
          $next = $page + 1;                            //next page is page + 1
          $lastpage = ceil($total_pages/$limit);        //lastpage is = total pages / items per page, rounded up.
          $lpm1 = $lastpage - 1;                        //last page minus 1
          /* 
          Now we apply our rules and draw the pagination object.
          We're actually saving the code to a variable in case
          we want to draw it more than once.
          */
  
          $pagination = "";
          if($lastpage &gt; 1)
          {
              $pagination .= "&lt;div class=\"pagination\"&gt;";         //previous button
              if ($page &gt; 1) 
                  $pagination.= "&lt;a href=\"$targetpage?page=$prev\"&gt;« previous&lt;/a&gt;";
              else 
                  $pagination.= "&lt;span class=\"disabled\"&gt;« previous&lt;/span&gt;";    
              //pages
              if ($lastpage &lt; 7 + ($adjacents * 2))    //not enough pages to bother breaking it up
              {
                  for ($counter = 1; $counter &lt;= $lastpage; $counter++)             {
                      if ($counter == $page)
                          $pagination.= "&lt;span class=\"current\"&gt;$counter&lt;/span&gt;";
                      else
                          $pagination.= "&lt;a href=\"$targetpage?page=$counter\"&gt;$counter&lt;/a&gt;";                    
              }         }         elseif($lastpage &gt; 5 + ($adjacents * 2))    //enough pages to hide some
              {
                  //close to beginning; only hide later pages
                  if($page &lt; 1 + ($adjacents * 2))                     {
                      for ($counter = 1; $counter &lt; 4 + ($adjacents * 2); $counter++)
                      {
                          if ($counter == $page)
                              $pagination.= "&lt;span class=\"current\"&gt;$counter&lt;/span&gt;";
                          else
                              $pagination.= "&lt;a href=\"$targetpage?page=$counter\"&gt;$counter&lt;/a&gt;";                    
                      }
                      $pagination.= "...";
                      $pagination.= "&lt;a href=\"$targetpage?page=$lpm1\"&gt;$lpm1&lt;/a&gt;";
                      $pagination.= "&lt;a href=\"$targetpage?page=$lastpage\"&gt;$lastpage&lt;/a&gt;";        
                  }             //in middle; hide some front and some back
                  elseif($lastpage - ($adjacents * 2) &gt; $page &amp;&amp; $page &gt; ($adjacents * 2))             {
                      $pagination.= "&lt;a href=\"$targetpage?page=1\"&gt;1&lt;/a&gt;";
                      $pagination.= "&lt;a href=\"$targetpage?page=2\"&gt;2&lt;/a&gt;";
                      $pagination.= "...";
                      for ($counter = $page - $adjacents; $counter &lt;= $page + $adjacents; $counter++)
                      {
                          if ($counter == $page)
                              $pagination.= "&lt;span class=\"current\"&gt;$counter&lt;/span&gt;";
                          else
                              $pagination.= "&lt;a href=\"$targetpage?page=$counter\"&gt;$counter&lt;/a&gt;";                    
                      }
                      $pagination.= "...";
                      $pagination.= "&lt;a href=\"$targetpage?page=$lpm1\"&gt;$lpm1&lt;/a&gt;";
                      $pagination.= "&lt;a href=\"$targetpage?page=$lastpage\"&gt;$lastpage&lt;/a&gt;";        
                  }             //close to end; only hide early pages
                  else
                  {
                      $pagination.= "&lt;a href=\"$targetpage?page=1\"&gt;1&lt;/a&gt;";
                      $pagination.= "&lt;a href=\"$targetpage?page=2\"&gt;2&lt;/a&gt;";
                      $pagination.= "...";
                      for ($counter = $lastpage - (2 + ($adjacents * 2)); $counter &lt;= $lastpage; $counter++)
                      {
                          if ($counter == $page)
                              $pagination.= "&lt;span class=\"current\"&gt;$counter&lt;/span&gt;";
                          else
                              $pagination.= "&lt;a href=\"$targetpage?page=$counter\"&gt;$counter&lt;/a&gt;";                    
              }             }         }
              //next button
              if ($page &lt; $counter - 1)
                  $pagination.= "&lt;a href=\"$targetpage?page=$next\"&gt;next »&lt;/a&gt;";
              else 
                  $pagination.= "&lt;span class=\"disabled\"&gt;next »&lt;/span&gt;";
              $pagination.= "&lt;/div&gt;\n";
      } ?&gt;
  
      &lt;?php
          while($row = mysql_fetch_array($result))
          {
              echo '&lt;a href="http://geatzo.com/do123.php?uid='.$row['id'].'"&gt;&lt;img src="http://www.geatzo.com/images/coins.jpg" height="100px" width="100px"/&gt;';
              echo '"&lt;p&gt; &lt;/p&gt;';
              echo '"You will earn&lt;b&gt;"'.$row['coins'].'"&lt;/b&gt;Coins"&lt;p&gt; &lt;/p&gt;';
              echo '"Posted By "'.$row['username'].'&lt;p&gt; &lt;/p&gt;';
              echo '"Site you will be viewing "'.$row['url'].'&lt;p&gt; &lt;/p&gt;';
          }
      ?&gt;
  
      &lt;?=$pagination?&gt;
  
  
  
  &lt;/p&gt;
  </code></pre>
  
  <p>I want to put that php in a a html div
  here is the html</p>
  
  <pre><code>&lt;div class="ptcbox-link"&gt;&lt;a href="http://www.mysite.com/gpt.php?v=entry&amp;amp;type=ptc&amp;amp;id=6960&amp;amp;sid=TWk0Mk1Ea3hORGc1TVRB&amp;amp;sid2=TWk0M&amp;amp;siduid=186998&amp;amp;"&gt;&lt;/a&gt;&lt;/div&gt;
                  &lt;div class="ptcbox-value-w1"&gt;
                      &lt;div class="ptcbox-value"&gt;$2&lt;/div&gt;
                      &lt;div class="ptcbox-seconds"&gt;30 seconds&lt;/div&gt;
                  &lt;/div&gt;
  </code></pre>
  
  <p>I want there to be like <a href="http://img841.imageshack.us/img841/6651/unledfte.png" rel="nofollow">http://img841.imageshack.us/img841/6651/unledfte.png</a> the div tags for each different result a new box for each result</p>
  
  <p>Thanks</p>
  
  <p>P.s the html code and php code works both works i just wanna put them together in a while </p>