Jump to content

Archived

This topic is now archived and is closed to further replies.

Jay2391

phpMyAdmin

Recommended Posts

I created a DB with a table call [b]users[/b] ....

I am trying to create a field for a password on the table ...
but when i go to types I do ot have a password type option...

So what i did I made it a character field 30 charactes...

I added a test record and now I can add a function "password" to the password field...

now ths is manualy I want to do this without having to change every record...one by one


???

Share this post


Link to post
Share on other sites
There is no such thing as a password data type in mysql. Also, assuming the [i]password[/i] function you speak of is the mysql PASSWORD() function. This should not be used by client code... it is an internal function for use by mysql.

Just store your passwords as an [url=http://php.net/md5]md5[/url]'d string.

Share this post


Link to post
Share on other sites
Try clicking the link I provided.

Share this post


Link to post
Share on other sites
Okay that option is not available either here is a screen shoot of what my table field looks like

[attachment deleted by admin]

Share this post


Link to post
Share on other sites
this is acomplte list screen shot

[attachment deleted by admin]

Share this post


Link to post
Share on other sites
Your password field is going to be VARCHAR.

md5 is a php function you call on the password [i]before[/i] inserting it into the database.

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.