Where is customer/user login information stored on my database?

[jonathanagomaa]

This is kind of a strange question.

But is there a place where I can access the contact registration information users had imputed from my root folder? I know they normally come up in the back office customer tab, however there is an error in one of my modules and I need to know a few customers login information to verify their account for a client.

Jonathan

[vekia]

you're talking about ps_customer table in your database

(also ps_address - where you can find informations about customer addresses)

[Lester Frischman]

I want to collect the information on my customers who place orders on my site www bestbuyuniforms com -

I only want the Day and Month for for his/her birthday - but not the year..    how do i do that? currently the designer included the year.. thanks   lester 

[vekia]

i totally don't know what and where you want to display.

customer birthday? but where? in front office? back office?

please shed some light on this case

 

thanks in advance

[jonathanagomaa]

Thank you Vekia, it helped!

However not all the information is there. Like the phone number Is it because something is broken possibly in my logic?

JA

[vekia]

phone number is stored in ps_address table