How do I add fields to the Customers table?

[grwd]

:?: How do I go about adding fields to the Customers table without messing up osCommerce?

[JHouse]

First you gotta add the desired fields to your database, then you gotta add the related code to the desired page(s).

 

If you know sql and some php, this shouldn't be to large of a task. If not...uhhhh, hire somebody???

 

Good luck.

[grwd]

First you gotta add the desired fields to your database, then you gotta add the related code to the desired page(s).  

 

If you know sql and some php, this shouldn't be to large of a task. If not...uhhhh, hire somebody???

 

Good luck.

 

Is it best to add the new fields to the END of the existing fields in the table?

Or does it matter to the existing PHP code?

[JHouse]

+++++++++++++++++++++++++++++++++++++++++++

Is it best to add the new fields to the END of the existing fields in the table?

Or does it matter to the existing PHP code?

+++++++++++++++++++++++++++++++++++++++++++

 

As far as I know, and I'm definitely no expert whatsoever, you want to add the desired fields to the customer info table. I don't think sequence makes a difference, but I could be totally wrong.

 

The php code should be added before or after (depending on your desires) to the related php tags. So, if you wanted to add a 'NickName' field, you'd probably want to add it just after the customer's last name located on the New User page (login.php?).

 

Hope this helps. Don't go blowing shit up now.

 

Peace.