New field in reviews table...

Regular Joined: Mar 11, 2005 Posts: 67

I have added new field in nuke_reviews table called CAT <- as category.

If I add cat number:
1 <- photoshop review
2 <- book review
3 <- movie review

Now I would like to see right block only in Photoshop reviews (cat no. 1).

After:

Code:

$pagetitle = "- $module_name";

I added:

Code:

   if ($cat == 1) {


$index = 1; 


     } else {


$index = 0; 


    }

Of course it didn't work.

Does anyone else have idea how to do that?

Site Admin/Owner Joined: Aug 27, 2002 Posts: 17088

How is $cat being populated? You would have to place that code after a call to your MySQL reviews table. Normally that hasn't happened before the $pagetitle statement.

Posted: Sat Mar 26, 2005 10:55 am

I did one test...

instead of $cat I inserted $id and change number 1 to number of random review, which worked.

But I can't find anywhere where $id is populated Sad

Posted: Sat Mar 26, 2005 11:00 am

I tried this but without it didn't work:

Code:

$result = sql_query("SELECT cat FROM ".$prefix."_reviews", $dbi);


while(list($cat) = sql_fetch_row($result, $dbi)) {





   if ($cat == 1) {


$index = 1; 


     } else {


$index = 0; 


    }


    }

Posted: Sat Mar 26, 2005 11:24 am

I have no idea why you mention $id? Put this statement right ahead of your if test: die($cat);