Product_reviews.php Problem

[Benjjj6]

Hey

 

When i view product reviews or try to write one on my site it always has "iPod AV Cable" on the page where it should say something else, preferably the name of the product you are reviewing.

 

It is probably easier just to show you an example: http://discountmania.co.uk/product_reviews...ucts_id=1074%22

 

How can i change it from saying "iPod AV Cable" (to the right of where it says PRODUCT CATEGORIES) to something more relevant?

 

:thumbsup:

[Benjjj6]

any ideas anyone?

[Velveeta]

any ideas anyone?

Are you maybe selling nothing but Ipod AV Cables throughout your entire store? j/k :) It looks like for some reason, it's either got that name hardcoded into the php file, or else it's always pulling back that name when it queries for the product info to display there... It might be helpful if you could post that file as something we could read through, maybe just copy it to another filename.txt and give us the url here... When I manually go to the reviews page for that product (http://discountmania.co.uk/reviews.php?product_id=1074), I see the right product name above that one... So there's definitely something fishy going on somewhere...

 

Richard.

[Benjjj6]

well if you go here:

 

http://discountmania.co.uk/maximo-psp-gel-...ear-p-1074.html

 

and then click reviews you can see it says IPOD AV CABLE.

 

 

Which file do you need i will happily post it.

[Velveeta]

well if you go here:

 

http://discountmania.co.uk/maximo-psp-gel-...ear-p-1074.html

 

and then click reviews you can see it says IPOD AV CABLE.

Which file do you need i will happily post it.

product_reviews.php, just copy it to another filename as like product_reviews.txt, and post back here when it's ready for viewing...

 

Richard.

[Benjjj6]

Here you go, i hope you can get it working properly again :D thanks

 

http://www.discountmania.co.uk/product_reviews.txt

[Velveeta]

Here you go, i hope you can get it working properly again :D thanks

 

http://www.discountmania.co.uk/product_reviews.txt

Hmmm, I'm not spotting anything wrong, especially considering that it's pulling the right products_description... If you have phpMyAdmin or something, try executing this query, and tell me what it shows for the products_name field:

 

select p.products_id, p.products_model, p.products_image, p.products_price, p.products_tax_class_id, pd.products_name from products p, products_description pd where p.products_id = '1074' and p.products_status = '1' and p.products_id = pd.products_id and pd.language_id = '1'

 

Richard.

[Benjjj6]

i ran that query in phpMyAdmin and got this, does it mean anything to you?

 

MySQL returned an empty result set (i.e. zero rows). (Query took 0.0004 sec)

SQL query: 

SELECT p.products_id, p.products_model, p.products_image, p.products_price, p.products_tax_class_id, pd.products_name
FROM products p, products_description pd
WHERE p.products_id = '1074'
AND p.products_status = '1'
AND p.products_id = pd.products_id
AND pd.language_id = '1'
LIMIT 0 , 30

[Velveeta]

i ran that query in phpMyAdmin and got this, does it mean anything to you?

 

MySQL returned an empty result set (i.e. zero rows). (Query took 0.0004 sec)

SQL query: 

SELECT p.products_id, p.products_model, p.products_image, p.products_price, p.products_tax_class_id, pd.products_name
FROM products p, products_description pd
WHERE p.products_id = '1074'
AND p.products_status = '1'
AND p.products_id = pd.products_id
AND pd.language_id = '1'
LIMIT 0 , 30

Hmmm, can you take a look at your language table and tell me what # english is for your languages? I assumed it was 1, but I guess I was wrong... Get back to me with that, and I'm taking off from work right now, be home in about 45 minutes and I'll check back in with you...

 

Richard.

[Benjjj6]

^ could you tell me how to do that?

 

i went to phpMyAdmin and looked at my languages table (i think :() but i couldnt really tell anything from it

[Benjjj6]

hello? are you still there?