Oh, and if you wanted to do it after you inserted, you could
just do:
mysql_query("UPDATE tablename SET pwfieldname = md5(pwfieldname);");
On Wed, 2002-10-09 at 08:39, Verdon Vaillancourt wrote:
> Hi,
>
> I hope this question isn't too basic...
>
> I have a flat file (CSV) that I want to import into a mySQL db via
> phpMyAdmin. The file has about 1200 rows and is in a format like:
> "value","value","password","value","value","etc"
> The passwords are in clear text. I need them to be encrypted in md5.
>
> Is there any advice out there as to how I could process this flat-file
> before I import into my db or after the fact?
>
> Thanks, verdon
> Ps. Please cc me if replying to list as I am on digest mode
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
