for this particular pages i need

<li><a href="about_us.php?abtid=2" title="About Us" onclick="function changetab();">About Us</a></li> 
              <li><a href="contact_us.php" title="Contact Us">Contact Us</a></li> 
              <li><a href="faq.php?abtid=4" title="FAQ">FAQ</a></li> 
              <li><a href="terms_of_use.php" title="Terms Of Use">Terms Of Use</a></li> 




$abtid = $_SESSION['abtid'];


$sql1 = mysql_query("SELECT st.`id`,st.Catagory, st.`title`, st.`description`, st.`keywords`,sft.id,sft.titles FROM `seo_title` st JOIN seo_footer_title sft ON sft.id=st.Catagory WHERE st.Catagory='$abtid'");
$result = mysql_fetch_array($sql1);
if($result)
{
    echo"hhh". $result['titles'];
    echo $result['description'];
    echo $result['keywords'];




?>
<?php   //}
//}
?> </title>
<meta id="mtlink" name="url" content="">
<meta id="mtdesc" name="description" content="<?php echo $result['description']; ?>" />
<meta id="mtkwrds" name="keywords" content="<?php echo $result['keywords']; ?>" />
<?php } ?>

but in this am getting only url for that pages

Too little information... What are you expecting? How does your table structure look?

These would be helpful bits of information.

here is my tables
main table

CREATE TABLE IF NOT EXISTS `seo_title` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `Catagoryid` varchar(100) NOT NULL,
  `title` varchar(100) NOT NULL,
  `description` longtext NOT NULL,
  `keywords` longtext NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;

category list

CREATE TABLE IF NOT EXISTS `seo_footer_title` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `titles` longtext NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=10 ;



INSERT INTO `seo_footer_title` (`id`, `titles`) VALUES
(1, 'Home'),
(2, 'About Us'),
(3, 'Contact Us'),
(4, 'FAQ');

Still not enough info, what data does seo_title contain?

What do you expect the output to be when you run a query? What is the query you are running.

Still not enough info, what data does seo_title contain?

INSERT INTO `seo_title` (`id`, `Catagory`, `title`, `description`, `keywords`) VALUES
(1, '2', 'beautyspa in bangalore', 'about some information', 'beautyspa'),
(2, '1', 'Test', 'testttt', 'testttt tt');




<?php

$abtid = $_SESSION['abtid'];

$sql1 = mysql_query("SELECT st.`id`,st.Catagory, st.`title`, st.`description`, st.`keywords`,sft.id,sft.titles FROM `seo_title` st JOIN seo_footer_title sft ON sft.id=st.Catagory WHERE st.Catagory='$abtid'");
$result = mysql_fetch_array($sql1);
if($result)
{
    echo"hhh". $result['titles'];
    echo $result['description'];
    echo $result['keywords'];




?>
<?php   //}
//}
?> </title>
<meta id="mtlink" name="url" content="">
<meta id="mtdesc" name="description" content="<?php echo $result['description']; ?>" />
<meta id="mtkwrds" name="keywords" content="<?php echo $result['keywords']; ?>" />
<?php } ?>

for this you have to add title ,description to db with package ...
when package call on page then echo into particular portion