creating a (extra) username

[Steph Mu Bai]

Hello Ppl,

 

Ok, sorry as this is prob a real easy one but...

 

I have enter in the customers table a new var :

 

customers_username

 

i've implemeneted that in create_account, so that when registering i've checked, the new info get to the right place in the database (ie stored under customers_username)

 

Now i want to use this new var when ppl post reveiws let's say (instead of their rela name to appear)

 

so in product_reviews i've done the following (adding the username)

 

$customer_query = tep_db_query("select customers_firstname, customers_username, customers_lastname from " . TABLE_CUSTOMERS . " where customers_id = '" . (int)$customer_id . "'");

$customer = tep_db_fetch_array($customer_query);

 

 

 

 

and then where the name will be displayed (or anyway the only place i've found a name displayed ;))

 

<td class="main"><?php echo '<b>' . SUB_TITLE_FROM . '</b> ' . tep_output_string_protected($customer['customers_username']);

?></td>

 

 

and then, this isn't printing anything in place of the name, so it doesn't know the var i guess

 

but what did i miss ???

 

Any help would just be awesome :))

 

Steph