Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Product Reviews 1/2 working - need advice!


ryno267

Recommended Posts

First off I must say that I have searched the boards with no resolve, and have also posted in some of the other topics to try and 'refresh' some of the problems again.

The only thing I really modified from the original code was putting the reviews section in the left column by a php require, which should have no effect on the code on the "product_reviews_info.php" page.

On all the main pages - the infoBOX is working fine and when you click the arrow, which brings you to the "reviews.php" page - those are working as well, but are abbreviated... Is that by design? The only page NOT showing the reviews is the "product_reviews_info.php" page.

This is what is displayed:

by T 	 Date Added:
T
Rating: [T of 5 Stars!]

So it is only displaying the first letter of the review... in this case the "T" the first word, which is "This". And where the image is.. it displays a T with a 'click to enlarge' under it... And for the stars... all there is is a php made image with "T of 5 Stars!" and no stars image at all...

 

Obviously this is a big problem and I need to fix this issue...

 

I have seen that guys did stress concern for the database structure involving the reviews, therefore I have copied mine here - as everything looks cool in the DB.

 

"reviews" table

Field....................Type ..........Null........Default.........Extra
----------------------------------------------------------------------
reviews_id..............int(11)..........No.....................auto_increment 
products_id.............int(11)..........No.........0
customers_id............int(11)..........Yes........NULL
customers_name..........varchar(64)......No
reviews_rating..........int(1)...........Yes........NULL
date_added..............datetime.........Yes........NULL
last_modified...........datetime.........Yes........NULL
reviews_read............int(5)...........No.........0

"reviews_description" table

Field..............Type ..........Null........Default.........Extra
------------------------------------------------------------------
reviews_id........int(11)..........No ...........0
languages_id......int(11)..........No............0
reviews_text......text.............No    

 

The full description seems to be fine in the database under 'reviews_text' but seems to be abbreviated (probably just for phpmyAdmin tho).

 

Just FYI - I'm using MS2

 

Please Advise with any ideas or help.. Thanks osC community!!!!

Link to comment
Share on other sites

open product_reviews_info.php

 

search and replace

 

find: $review

 

replace with: $myreview

 

note: myreview can be anything really so long as it doesnt interact with existing variables.

 

worked for me hope that helps. thx to lucas the php guru

Jeremy Dawes

 

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...