Forums

slayboy

my question now is everything is working like my template and the content all i want is to include keywods description and title for each page different it is giving me headache i have a database name pages it has 6 columns id,name,title,description,keywords ,status. All my pages are working that are from the database what i want now is my pages changes with the name i from the database that is pages changing with the page thanks

<?php 
// Set document:
include ('config/setup.php');
if(!isset($_GET['page'])) {
      
           $pg= 'page';
      }else{
           $pg= $_GET['page'];
      }
  
?>

this is my php code

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

http://www.w3.org/1999/xhtml"> help

    <div id="logo">
  <a class="logo" =pic">

  <div class="right">
  <?php include('template/right_logo.php');?>
  </div>
</div>  
  <div id="header">
  <?php include('template/header.php');?>
</div>




  <div id="main">

    <!-- ### Main Left Start      ###   -->

      <div id="left">
  <?php //include('content/'.$pg.'.php');
$q="SELECT*FROM pages WHERE name='$pg' ";

  $r=mysqli_query($dbc,$q);

  $page= mysqli_fetch_assoc($r);

  echo '<div  class="content_body">'.$page['body'].'</div>';
?>

    </div>

    <!-- ### Main Left End    ###   -->


    <!-- ### Main Rigt Start  ###   -->
    <div id="right">
          <?php include('template/right.php');?>
    </div>

    <!-- ### Main Rigt End    ###   -->   

    <div class="clear"></div>

      <div id="footer">
          <?php include('template/footer.php');?>

          </div>

  </div>


</body>