Help for finish dynamic title page script

[bubbles.br]

Hi,

I'm tried optimize title of dynamic pages of my site and I'd liked add the name of category ($namecat) in page title of article (../article.php?id=41) but, I can't finish it.

if($_GET['id']) {
        $sql = mysql_query("SELECT title, subtitle FROM articles WHERE id=".$_GET['id']);
        $row = mysql_fetch_array($sql, MYSQL_ASSOC);
        $title=$row["title"];
        $subtitle=$row["subtitle"];
        if (empty($subtitle)) {
        $pagetitle = "$title | Articles"; } else {
        $pagetitle = "$title - $subtitle | Articles";   } } 

liked ($namecat):

 $pagetitle = "$title | $namecat | Articles"; } else {
     $pagetitle = "$title - $subtitle | $namecat | Articles";   } } 

How I do it?

CREATE TABLE `table_articles` (
  `id` tinyint(4) NOT NULL auto_increment,
  `namecat` varchar(255) NOT NULL default '',
  `descat` text NOT NULL,
  PRIMARY KEY  (`id`,`nomecat`)
) TYPE=MyISAM AUTO_INCREMENT=85 ;

CREATE TABLE `articles` (
  `id` int(11) NOT NULL auto_increment,
  `cat` int(11) NOT NULL default '0',
  `title` varchar(255) NOT NULL default '',
  `subtitle` varchar(255) NOT NULL default '',
   `article` longtext NOT NULL,
   PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=49 ;

Sorry for english!

[asp_funda]

Come Again??
I don't think I understand what you want. Do you want to create the database table or what?

[Nick]

Well, you will have to select the category name in your query, for one. Then do another query to use the int of the cat to select the namecat from the other table. Like so:

if($_GET['id']) {
        $id = mysql_escape_string($_GET['id']);
        $sql = mysql_query("SELECT cat, title, subtitle FROM articles WHERE id='$id'");
        $row = mysql_fetch_array($sql, MYSQL_ASSOC);
        $cat = $row["cat"];
        $title=$row["title"];
        $subtitle=$row["subtitle"];
         $CatQuery = mysql_query("SELECT namecat FROM table_articles WHERE id = '$cat'");
$CatRow = mysql_fetch_array($CatQuery, MYSQL_ASSOC);
$namecat = $CatRow["namecat"];
        if (empty($subtitle)) {
        $pagetitle = "$title | $namecat | Articles"; } else {
        $pagetitle = "$title - $subtitle | $namecat | Articles";   } } 

[bubbles.br]

..I don't think I understand what you want...

I want add the variable namecat in pagetitle.

Well, you will have to select the category name in your query, for one. Then do another query to use the int of the cat to select the namecat from the other table.

Perfect!
I understand all and it works now.
Thank you very much Possibility and asp_funda for reply!
bye.

[asp_funda]

ok, glad that you got it working.

[bubbles.br]

Hi,

Could you help-me for this again, please? I've tried add the name of category ($cattitle) in page title of category repairs (index.php?view=cat&id=21) and view repair page (index?view=repair&did=67) but, I've got some difficulties.
The cattitle variable doesn't appear.

if($_GET['did']) {
        $did = mysql_escape_string($_GET['did']);
        $sql = mysql_query("SELECT dicastitle FROM repair WHERE dicasid='$did'");
        $row = mysql_fetch_array($sql, MYSQL_ASSOC);
        $dicastitle = $row["dicastitle"];
       
        $CatQuery = mysql_query("SELECT cattitle FROM repair_cat WHERE catid='$dicasid'");
        $CatRow = mysql_fetch_array($CatQuery, MYSQL_ASSOC);
        $cattitle = $CatRow["cattitle"];
         
        $pagetitle = "$dicastitle | $cattitle | Repair";   } 
        
if($_GET['catid']) {    
    $catid = mysql_escape_string($_GET['catid']);    
    $sql = mysql_query("SELECT cattitle FROM repair_catWHERE catid='$catid'");
    $row = mysql_fetch_array($sql, MYSQL_ASSOC);
    $cattitle = $row["cattitle"];        
       $pagetitle = "$cattitle | Repair";            
                } 

    CREATE TABLE `repair` (
  `dicasid` bigint(5) NOT NULL auto_increment,
  `catid` bigint(5) NOT NULL default '0',
  `dicastitle` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`dicasid`),
  KEY `catid` (`catid`)
) TYPE=MyISAM AUTO_INCREMENT=84 ;

CREATE TABLE `repair_cat` (
  `catid` bigint(5) NOT NULL auto_increment,
  `cattitle` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`catid`),
  KEY `catparent` (`catparent`)
) TYPE=MyISAM AUTO_INCREMENT=32 ;

Thank you!!!

[bubbles.br]

It's working now after some changes in the code. Thank's.