> $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/ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php