Change Reviews By to First name Only?

[wwanthony]

Hi,

I have searched through these forums and contributions and even tried to it myself for a while but I have come to a dead end.

 

I am desperately trying to change the text for product_review.php and product_reviews_info.php to only display the firstname where it says by first last name.

 

I know this is not exactly a drastic upgrade to the cart but I would be really happy if someone could help me to do it as I think its a good idea to have a little privacy for the person placing the review.

 

thankyou,

Anthony

[Guest]

change customers name in reviews.php to first name . ..

 

osCommerce is fairly strainghtforward. whatever you want to change, look in that application for what you are trying to change. then copy the line, coment out the original and change the copied line to what you need.

 

you can change the parameter where reviews pulls in the whole name to just the customers first name

[wwanthony]

change customers name in reviews.php to first name . ..

 

osCommerce is fairly strainghtforward.  whatever you want to change, look in that application for what you are trying to change.  then copy the line, coment out the original and change the copied line to what you need.

 

you can change the parameter where reviews pulls in the whole name to just the customers first name

<{POST_SNAPBACK}>

 

 

Hi Mibble,

thanks for your help it very much appreciated.

Please could you tell me what I should change.

 

Is it this part from reviews.php?:

  $reviews_query_raw = "select r.reviews_id, left(rd.reviews_text, 100) as reviews_text, r.reviews_rating, r.date_added, p.products_id, pd.products_name, p.products_image, r.customers_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.reviews_id = rd.reviews_id and p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "' and rd.languages_id = '" . (int)$languages_id . "' order by r.reviews_id DESC";

 

I can see it pulls "r.customers_name", should I change it to "r.customers_first_name"?

 

Thanks again for your help.

Anthony