»
 

Go Back   ResellerRatings Store Ratings > ResellerRatings Forums > Tech Support

Reply
 
LinkBack Thread Tools Display Modes
Old 11-26-2003, 08:03 AM   #1 (permalink)
Registered User
 
Agent_Embryo's Avatar
 
Join Date: Oct 2001
Location: Sweden
Posts: 1,260
Agent_Embryo is on a distinguished road
Send a message via ICQ to Agent_Embryo
MySQL Questions

So I'm building a site for my mp3 songs using PHP and MySQL...

I want people to be able to register an account and let them post reviews.

So I've started making the users table in MySQL, but I'm confused about datatypes in MySQL as I've only used Access before.

What I need to know is how to encrypt the password field and what datatype to use for it.

Thanks
/AE

Agent_Embryo is offline   Reply With Quote
Old 11-26-2003, 09:30 AM   #2 (permalink)
Registered User
 
drizzle's Avatar
 
Join Date: Oct 2001
Location: Louisiana, USA
Posts: 170
drizzle is on a distinguished road
Send a message via ICQ to drizzle Send a message via Yahoo to drizzle
You can use either the md5 function or the MySQL PASSWORD hash.

Use varchar(255) for the datatype.
drizzle is offline   Reply With Quote
Old 11-27-2003, 09:43 AM   #3 (permalink)
Registered User
 
Agent_Embryo's Avatar
 
Join Date: Oct 2001
Location: Sweden
Posts: 1,260
Agent_Embryo is on a distinguished road
Send a message via ICQ to Agent_Embryo
Thanks!
Agent_Embryo is offline   Reply With Quote
Reply




Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Most Active Discussions

Recent Discussions

All times are GMT -6. The time now is 02:56 PM.