Customer Reviews, their full name is diplayed?

paul3648:

I am using CONCAT on 1.5. Works for me.

You might want to check that you are editing product_reviews_write - there are two other product_reviews folders.

$customer_query = "SELECT customers_firstname, CONCAT(LEFT(customers_lastname,1),'.') AS customers_lastname, customers_email_address
FROM " . TABLE_CUSTOMERS . "
WHERE customers_id = :customersID";

Thanks it was in the correct place. However, your code with "CONCAT(LEFT" is slightly different than the one that was posted and your code works.

bluefirefly:

You can change a reviewers name after the fact by going into your database. I did this for a customer by going to my phpMyAdmin, found the zen_reviews table and manually edited my customers name for them. :smile:,

Thank you, bluefirefly for this info. This was a good "quick fix" while I'm trying to change my template.

Thanks everyone, this solved my issue. I swear this is the best coding forum in the world right now =) I've never even had to ask one question. Everything is all here!