dynamic title, keywords per page

[malatamil]

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

[iamthwee]

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

These would be helpful bits of information.

[malatamil]

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');

[iamthwee]

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.

[malatamil]

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 } ?>

[parveen5910159]

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