0

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

3
Contributors
5
Replies
29
Views
3 Years
Discussion Span
Last Post by parveen5910159
0

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

These would be helpful bits of information.

0

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

Edited by malatamil: change

0

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.

0

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

Edited by malatamil: data

0

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

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.