Stop the Reviews box display certain review

[Stephan (VS)]

I feel all products should star at a 50/100 rating. :)

 

Now I've made the reviews for all my products but I don't want those reviews appearing in the Reviews box in the right column.

 

What would be the safest option?

[steve_s]

I feel all products should star at a 50/100 rating. :)

 

Now I've made the reviews for all my products but I don't want those reviews appearing in the Reviews box in the right column.

 

What would be the safest option?

includes/column_right.php

find

 require(DIR_WS_BOXES . 'reviews.php');

change it to

// require(DIR_WS_BOXES . 'reviews.php');

 

Review box wont show in right column now

[Stephan (VS)]

lol, sorry but I Still want the box, I Just don't want a specific user's reviews to display. :lol:

 

The varaible they all have in common :

The

customer_id

last_modified

date_added &

they are the first 6000 reviews on the database.

[satish]

CREATE TABLE reviews (

reviews_id int NOT NULL auto_increment,

products_id int NOT NULL,

customers_id int,

customers_name varchar(64) NOT NULL,

reviews_rating int(1),

date_added datetime,

last_modified datetime,

reviews_read int(5) NOT NULL default '0',

PRIMARY KEY (reviews_id),

KEY idx_reviews_products_id (products_id),

KEY idx_reviews_customers_id (customers_id)

 

so

$random_select = "select r.reviews_id, r.reviews_rating, p.products_id, p.products_image, pd.products_name from " . TABLE_REVIEWS . " r, " . TABLE_REVIEWS_DESCRIPTION . " rd, " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_status = '1' and p.products_id = r.products_id and r.customers_id != 10 and r.reviews_id = rd.reviews_id and rd.languages_id = '" . (int)$languages_id . "' and p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "'";

);

 

r.customers_id!=10 here 10 needs to be replaced.

Code is in boxes/reviews.php

 

 

Satish

[Stephan (VS)]

Thanks! works like a charm. :D