RE: [PHP-DB] MD5 Update
| From: | John W. Holmes | Date: | Mon, 17 Mar 2003 00:32:25 +0000 |
| Subject: | RE: [PHP-DB] MD5 Update | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-26411@lists.php.net to get a copy of this message | ||
> $preencher = mysql_query("SELECT * FROM alemao");
> $update = mysql_query("UPDATE alemao SET codigo =
> md5(concat(nome,email))");
>
> mysql_close ($db);
>
>
> whats wrong with my code? when I tell him to
>
> <? if ($update) echo "Insert MD5";
> else echo "No"; ?>
>
> he returns "Insert MD5", but nothing happens in the db... whats wrong?
You're query is fine (assuming column names are correct), something has
to happen. What do you expect to happen? Your UPDATE query is going to
update every row in the table...
---John W. Holmes...
PHP Architect - A monthly magazine for PHP Professionals. Get your copy
today. http://www.phparch.com/